Sorting Question

[Guest]

I have created a report from a query. I also created a field that sums up the
total. I would like to know if there is a way I can sort the sum field by the
highest toal first. I can't seem to find a way to do it. Help!

 

[Allen Browne]

To sort a report by a total, that *total* will need to be in the query that
serves as its RecordSource.

Once you have the total in the query, you can then select that field in the
Sorting And Grouping box of your report. (View menu, in report design view.)

 

[Rick B]

I'd suggest you read the previous posts on the topic. The easiest way I
have found is to go to www.google.com, click the "groups" option, and enter
a search string starting with...

microsoft.public.access

I'd probably try...

microsoft.public.access report sort by totals

 

[Michael J. Strickland]

If the Sum is a field in your table or query, you can enter it in the
"Sorting & Grouping" section for your report. Open report in design mode and
Rt-Click the square button in the top left corner. Select "Sorting and
Grouping" from the drop down menu and select the Sum field. If you are
calculating the Sum in a report text box, enter the expression you use to
calculate the Sum (from the Control Source property of the text box) in the
sorting and grouping section.