General info...

  • Thread starter Thread starter Ute
  • Start date Start date
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
 
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.
 
Back
Top