Subtotals and Grand Totals

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

Still in the early learning stages....

Need help with an aging report. I need this report to show
the totals by aging group by vendor and then grand totals
at the end.

Example:
VendorName
Current: 1000.00 Over 30: 500.00 Over 60: 250.00

VendorName
Current: 300.00 Over 30: 0.00 Over 60: 100.00

Grand Totals
Current: 1300.00 Over 30: 500.00 Over 60: 350.00

Can someone point me in the right direction. I can format
a report that shows me all of the detail with a running
total, but I am having trouble with displaying just the
vendor subtotals and a grand total at the end.

Any guidance will be apprecited.
 
You need to create a grouping for the Vendor and show a group footer. Then
you simply put a =Sum(TheField) in the control source. Do the same in the
Report Footer.
Look for Sorting and Grouping on the Report menu bar.
 
One more question if you have time....

The report has all of the information I need but I want to
modify the layout. Currently the report lists the groups
(Current - Over 30 - Over 60) as rows under the vendor.
Ideally, these would be columns,

What I have:
VendorName1
Current 1000.00
Over 30 500.00
Over 60 250.00

VendorName2
Current 300.00
Over 30 0.00
Over 60 100.00

What I want:
Current Over 30 Over 60
VendorName1 1000.00 500.00 250.00
VendorName2 300.00 0.00 100.00

Hope this is as easy as my last question.
 
Back
Top