Create report in Access 2003 with subtotals

  • Thread starter Thread starter sverre
  • Start date Start date
S

sverre

Hi

I would like to create a quite simple reports based on a query. The query
contains
several group by columns of which ACCOUNT and Product should be used with
subtotals in the report . I would like to add subtotals to

1) ACCOUNT
2) ACCOUNT and PRODUCT

Is there any easy way to do this? I am a beginner on the report object and
would need some advice.

Thank you in advance!

Best regards
Sverker
 
Put a textbox into the Report Footer and type
=Sum([Account]) into it

or

=Sum([Account]) + Sum([Product])

if you want to add both

If you want to add up a group eg all the accounts for one client, then use
the Sorting Grouping box to Sort by that field and there, you can choose to
have a Group Footer or Header. You can copy and paste the control from the
report footer into the Group Header or Footer and it will now add up that
group.

Evi
 
Back
Top