[AccessD] SQL Error

I'm not sure what you're trying to say, but is there a reason not to
use:  ((Member.Rank)<>'WO1'))?

Charlotte Foust

-----Original Message-----
From: Dean Ellis [mailto:deanellis at iprimus.com.au] 
Sent: Tuesday, March 02, 2004 4:27 AM
To: AccessD
Subject: [AccessD] SQL Error


Hi All,



Can anybody help with the following line of Code. I created the SQL part
directly from the query window but I keep getting the error "Expected
end of statement at the "WO1" area



Me.Combo6.RowSource = "SELECT DISTINCTROW Member.[Regt Number], Member
Surname, Member.Rank FROM Member WHERE ((Not(Member.Rank)= "WO1")) ORDER
BY Member.Surname;"





Basically its a dropdown box that needs to leave out certain record
depending on the members rank



Any thoughts
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com