SELECT DISTINCT but exclude "None"

[biocentrism]

I am trying to write a SELECT DISTINCT query which excludes any result that = "None".

This is what I have written but it does not work:

SQL = "SELECT DISTINCT [Status] FROM TblMembership WHERE [Status] <> 'None""

Any ideas how to do this?

Thank you.

[alansidman]

crossposted: http://www.mrexcel.com/forum/microso...lude-none.html

Please read this link: http://www.excelguru.ca/content.php?184

[CJ_London]

'does not work' is not very helpful. It's almost the same as saying 'My washing machine isn't working - can you tell me why?'

what error messages are you getting? or it returns the wrong thing or what? The code you have posted on the other forum is different and should work. The code here will generate an error