How to 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.

 

[Joe4]

That should work.

What does your data look like?
What are you getting for your results?
Where are you putting this statement, and what are you trying to do with it?

 

[alansidman]

strSql = "SELECT distinct tblMembership.Status FROM tblMembership WHERE (((tblMembership.Status)<>""none""));"

This works for me

 

[Joe4]

I see it didn't take you too long before your cross-posted this question: SELECT DISTINCT but exclude "None"

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links to the other thread (see rule #13 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.