Averages in a report.

  • Thread starter Thread starter Rog
  • Start date Start date
R

Rog

I have a query that I need to run several times, each time with a different
filter on one specific field. I then want to run a report containing and
average calculated from the sum of each query for a specific field divided
by the records returned each time.

The source data is quite large so preferably the whole report needs to be
automated.

Can anyone give me some pointers please without me having to get into
programming!?

Regards.
Roger.
 
Hi,


Is it possible that you do it the hard way? Have you explored the
possibilities to do a Crosstab query? As example, if you try to get the sum
of sales, per item, per month, that exactly what it can do for you, in just
one step.

If you tell us what you want get, rather than how you do to get it, it
is sometimes easier for anyone to suggest another way about "how to do" to
get the result you seek.




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top