Running a report based on aquery

[Jayne]

Can anyone tell me why when I run a query my records are sorted correctly by
a numerical field, but when I use this query to run a report they no longer
apear sorted correctly.

This is very frustrating and I don't know why this is happening!

Thank you

 

[Allen Browne]

In report design view, open the Sorting And Grouping Dialog.
Choose the field(s) you wish to sort by.

In general, there's no point sorting in the query, because the report's
sorting is defined by the Sorting And Grouping.

 

[John Spencer]

A report ignores any Order By clause used in the query.

If you want to specify a sort or group in a report, you use the Sorting
and Grouping menu item located in the View menu.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Jayne]

Thank you! Sorted, literally!

If you knew how long this had been driving me mad for.....

 

[Jayne]

Thank you too! (see reply to Allen)

A report ignores any Order By clause used in the query.

If you want to specify a sort or group in a report, you use the Sorting
and Grouping menu item located in the View menu.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================