Multiple Sorting on Report

C

cjhoney

I have an Access report that includes sorting an grouping. The firs
sort is by Section, then by a ReportNo, but I also a a printorde
field. I need to have my report print by Section, then ReportNo an
then within the ReportNo, it needs to sort ascending by Printorder.
The report is developed from a query. If I change my sorting order t
Section, PrintOrder, then ReportNo then I lose the proper grouping fo
ReportNo.

I would appreciate a little help with this problem.
Thank you!
:confused
 
D

Duane Hookom

Could you try again? What are your fields that you want to sort/group by? Is
there an issue with using these fields in the sorting and grouping dialog?

Maybe you can provide some sample records and desired sorting order to
illustrate your needs.
 
C

cjhoney

The Report should display like this

Section 1 - Sorting & Grouping - with footers & calculations

DRReportNo - Sorting & Grouping (asc) with footers & calculations
Then sorted by a printorder field asc

Section 1
100 Something
106 houses xxx xxx
100 cars xxx xxx
104 trees xxx xxx
Totals xxx xxx

224 Something Else
209 Etc xxx xxx
202 ex xxx xxx
Totals xxx xxx

Total Section 1 xxx xxx

If I change to sorting and grouping to printorder -it also changes m
report to group by printorder - I just want it sorted by printorde
within the grouping you see above.
Hope this helps you answerr my question. I know I should be able to d
this - and it might be simple - but for some reason my brain is no
working on this one!

Thanks for your anticipated help
 
D

Duane Hookom

Are we supposed to be able to understand which columns correspond with which
fields?
Are the 100 Something and 224 Something Else a grouping/sorting field?
 
Top