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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
I have tried these changes with the same result
Thanks for the suggestion

Allen Browne said:
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.

David said:
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.
Click to expand...
Click to expand...
 
Back
Top