report sort different from query sort

[antonyx]

i made a report based on a query. when i run the query, my results are sorted by Job Time Ascending, like i want...
when i made my report i chose job id as the main group priority in the wizard..

now in my report it displays the jobs in ID ascending, rather than Job time ascending as my query says..

i dont want to re-do the report it took ages.. how can i fix this?

 

[Bat17]

In design view View>Sorting and grouping... pick the field to sort by in there.

HTH

Peter

 

[antonyx]

cheers, it worked

 

[FreddieLeaf]

This is a good tip. Thanks.

P.S. For anyone reading this and you can find the Sorting and Grouping selection... it is in the Main Access Toolbar View|Sorting and Grouping, Not in the Design View Properties of the Report!!! I spent 1/2 looking for it!!