Subtotals and Grand Totals

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

 

[Roger Carlson]

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.

 

[Ted]

Roger -

Thank you for your help. That did it. Simple once you
know...

 

[Ted]

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.

 

[Guest]

You probably want to do a crosstab query and then link
the query to the report.