[AccessD] SQL Error

Dean
Try single quotes around W01 e.g. 'W01'
Richard

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