Chris has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Excel VBA Advanced course
Project Intro Intermediate course
Reports
Is there a way to 'subtotal' either qty, total price etc.. in a report?
As an example, it is possible to hide duplicates, and this gives a view similar to below:-
Product Name Order ID Amount
Cinammon 1 20
2 30
3 40
Ginger 4 10
5 15
Tumeric 6 50
by subtotalling, the view would look something like:-
Product Name Amount
Cinammon 90
Ginger 25
Tumeric 50
Many thanks
RE: Reports
Hello Chris,
Hope you enjoyed your Microsoft Access courses with BEST Training.
Thank you for your question regarding Subtotaling in reports
Yes, you can subtotal in a report. The simplest way is to use the Report wizard, group your ProductName and then on the next step (Sort), click on SUMMARY OPTIONS. You then get a chance to choose what you want to summarise, SUM, COUNT, AVERAGE, etc.
Once the report is setup via the wizard, you can then adjust it via the design view.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
