Put All at the top of the query results

[Drenda]

Can you please help - I have created a query which results in a list of munbers and "ALL" which I then use in a combo box on a form. My problem is that I would like "ALL" to be at the top of the list but, depending on the numbers in the query result, the ALL could be anywhere. I have tried ascending / descendin but with no luck

Any help would be appreciated

Thanks

 

[alvechurchdata]

Might not work for you but I do this by using "--All--" instead. The "--A" sorts before any other entry.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[dinger2121]

you could also put a calculated column in the query to use for sorting. It won't be displayed, but have it say when column A = "All" then 1, etc.
You can then sort by that other column and that should put it at the top of the output.