How do I sort a sum value for a group of records in an Access rep.

[Guest]

I am working in Access 2000; I have a report that summarizes customer data
across 5 fields and totals each customer’s in a total column. How can I get
the report to print in descending total dollars order? It now prints
alphabetically by customer name.

 

[Allen Browne]

Create a query as the source for the report.

In the query, create a calculated field to give you the total, by typing
something like this into the Field row:
Amount: CCur(Nz([Field1],0) + Nz([Field2],0) + ... + Nz([Field5],0))

Then open the report in design view.
Set its RecordSource to the name of the query.
Open the Sorting And Grouping dialog (View menu), and sort on the Amount
field.

 

[Guest]

I have tried these changes with the same result
Thanks for the suggestion

Create a query as the source for the report.

In the query, create a calculated field to give you the total, by typing
something like this into the Field row:
Amount: CCur(Nz([Field1],0) + Nz([Field2],0) + ... + Nz([Field5],0))

Then open the report in design view.
Set its RecordSource to the name of the query.
Open the Sorting And Grouping dialog (View menu), and sort on the Amount
field.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am working in Access 2000; I have a report that summarizes customer data
across 5 fields and totals each customer's in a total column. How can I
get
the report to print in descending total dollars order? It now prints
alphabetically by customer name.