[AccessD] SQL Error

Wouldn't the WHERE clause read as: 
WHERE (Not(Member.Rank = "WO1"))

JR

-----Original Message-----
From: Dean Ellis [mailto:deanellis at iprimus.com.au]
Sent: Tuesday, March 02, 2004 7: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



This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.