General info...

U

Ute

Can anyone point me to a general information site. I
simply want to generate queries (or reports) that sum
columns for sub-totals and totals.

The standard Access 200 Help seems to be useless re:
simple cookbook info. I don't want to be forced to export
to Excel.

Thank you,

Ute
 
J

John Spencer (MVP)

This is the best place I know, although for this particular problem, I would
post to
microsoft.public.access.reports

A query can only produce a total (or sub-total) at one level. Reports can do
this a multiple levels.

Use a query to generate your lowest level sub-total and base the report on that
query. Add groups to your report and in the group footer(s), you can use
controls to sum the various values.
 
Top