Reports

Resolved · Low Priority · Version 2003

Reports

Chris has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Excel VBA Advanced course
Project Intro Intermediate course

by - delegate Chris [3 posts] (2008 Jul 29 Tue, 16:31) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Reports

by - trainer Richard platinum contributer [814 posts] (2008 Aug 6 Wed, 09:58) Reply

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

· Why Do I Need To Use Access?
· Microsoft Access Tighten your Security Controls
· MS Access and Database Normalisation
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses

Please browse our web site to find out more about
'ms access+course' and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips