Sort Order

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

My report contains the following columns:
Product (a text field with the product names)
Total Charges
Receipts
Percent of Collection

I developed this report through the wizard & specified
sums, their percentages, & in summary detail only.

Now, I need to have the report to be sorted by the
largest "Total Charges" amounts, and cannot use the
sorting/grouping order box due to the summary detail.

I think I need to use a macro, but have no clue what I'm
doing.

Please help.

Thank you
 
You don't need a macro or any code. Create a totals query that groups by
product (or whatever) and totals the field value you need. Then add this
query to your report's record source and join the Product fields. Add you
total field to the report's records source so you can select it in the
sorting and grouping dialog.
 
Thanks for the help.
-----Original Message-----
You don't need a macro or any code. Create a totals query that groups by
product (or whatever) and totals the field value you need. Then add this
query to your report's record source and join the Product fields. Add you
total field to the report's records source so you can select it in the
sorting and grouping dialog.

--
Duane Hookom
MS Access MVP
--




.
Click to expand...
 
Back
Top