Sort Order

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.

--
Duane Hookom
MS Access MVP
--

"Mary" wrote in message
...
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

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
--

"Mary" wrote in
message
...
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


.