Sorting Problem

[drunkenneo]

I have written a query where it displays sorted data for two columns, but problem is its sorting on one column but not on another



When checking the query seperately its giving proper output, but in form view its sorting only on one column not on another. Please help

[ItsMe]

Your form has a place where you can put the sorting order in the forms properties.

Open your form. Use your sort order tool bar by clicking in the fields and clicking a to Z. Do it in the sequence you desire, Field A, Field B etc. Save your form by clicking the save Icon.

Go straight to viewing your form in edit view. You should see the code within your form's property settings for sorting. COPY IT and save it to a text file. It can get lost by you clicking save at the wrong moment.

The best way id to write out the SQL in the form's load event and assign it to the forms recordsource.

[drunkenneo]

Great i noticed i had two queries for record source and on load also, i rectified it. Thanks

[ItsMe]

I was double checking on my computer and it wasn't saving to form properties on sorting only on filter. I couldn't find the right code to put into the properties field for sort.

Oh well, at least you got what you need.

[ItsMe]

FWIW and for anybody who cares:

In the Sort field in the form's properties the syntax is
QueryName.FieldName, QueryName.FieldName2

While viewing your form you can go to advanced filter sorting from your tool bar and save your form. Then in edit view the syntax will appear in the properties box.