Order By.....

[Johnny42]

SELECT DESC,ITEMNO ,COMMENT3 FROM items where (isnumeric(ITEMNO)) and DESC like ('%" & TextBox1.Value & "%') "

I would like to sort this by DESC ...can this be done with the order by ?

 

[PHV]

ORDER BY 1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Johnny42]

Thanks...
PS how can I get this to work ? :
Set RS = CNN.Execute("SELECT """DESC""" , FROM items ")

 

[PHV]

???

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Johnny42]

one of my field names is DESC (description)

When I use this in a VBA module I get a reserved word error...however in access the query works...

Set RS = CNN.Execute("SELECT DESC , FROM items ")

 

[PHV]

Have you tried SELECT [DESC],...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Johnny42]

Yes....does not work...still getting keyword error

 

[Johnny42]

comma......there should not be a comma after DESC !!!!!!!

Set RS = CNN.Execute("SELECT DESC FROM items ")

 

[swampBoogie]

Set RS = CNN.Execute("SELECT ""DESC"" FROM items")

 

[Johnny42]

thanks

 

[pelajhia]

YOu should absolutely consider trying to get this field name changed. It really should never have been named DESC.