Sorting a query differently in different forms

[Guest]

hi to all
I have a query that serves as the souce for 3 different forms. In each
case, though, the sort order is different, so I can't actually apply the sort
in the query. How do I add the sort criteria for each form when I'm using
that form? In each case, the sort is based on 2 fields, both Ascending.

thank you in advance

 

[fredg]

hi to all
I have a query that serves as the souce for 3 different forms. In each
case, though, the sort order is different, so I can't actually apply the sort
in the query. How do I add the sort criteria for each form when I'm using
that form? In each case, the sort is based on 2 fields, both Ascending.

thank you in advance

In Report design view, click on the Data property tag.
On the Sort line, write:
[Field1],Field2]

where Field1 is name of the 1st sort and Field2 is the 2nd.

Save the change.
When wanting to sort this form, right click on a blank portion of the
form and select Apply Filter/Sort.