Create report in Access 2003 with subtotals


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
 
Ad

Advertisements

E

Evi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top