Subtotals

ainwood

New member
Local time
Yesterday, 22:54
Joined
Aug 23, 2008
Messages
4
Hi there,

Is it possible to subtotal in access like you can in excel?

I am trying to write a query that includes a list of invoice numbers, item quantities to produce a total per invoice but the item and quantity number is repeated.

I can do this in a report however interested to see if I can do this in a query.

Cheers, Access Virgin.
 
Use a report Group to generate a subtotal and the Report footer to generate the report total.

You can build an example with the report wizard.
 
Attached sample shows invoice line items and also includes Subtotals for each invoice
 

Attachments

Users who are viewing this thread

Back
Top Bottom