display averages

  • Thread starter Thread starter richg
  • Start date Start date
R

richg

I would like to display the previous months averages while
showing the current months results and averages.
 
So, What is the question?
I think you'll be looking at grouping with group footers
and using < Average([YourField]]) >
Post back if you have a more specific question.
Fons
 
My question is : How would I display the averages of the
previous months results , while display the current months
results and averages? I am currently printing reports for
customers that show their accumulated test results for the
month. (e.g. The reaults are from 6/1/04 to 6/30/04 and
next month would be 7/1/04 - 7/31/04) What I would like to
do is show the previous months' average (e.g. May 04)
along with the current months' (e.g. June 04) results and
avgs.
Sorry for not being so clear before.
-----Original Message-----
So, What is the question?
I think you'll be looking at grouping with group footers
and using < Average([YourField]]) >
Post back if you have a more specific question.
Fons
-----Original Message-----
I would like to display the previous months averages while
showing the current months results and averages.
.
.
 
Sorry it took a while to get back. (Got to work to earn a
living also).
The way to approach your report is to create two reports
which it appears is no problem. Than include one as the
subreport to the other. You can relate the reports if
applicable to one another by month and year if this is
what you want.
Hope this gets you going in the desired direction.
Fons
-----Original Message-----
My question is : How would I display the averages of the
previous months results , while display the current months
results and averages? I am currently printing reports for
customers that show their accumulated test results for the
month. (e.g. The reaults are from 6/1/04 to 6/30/04 and
next month would be 7/1/04 - 7/31/04) What I would like to
do is show the previous months' average (e.g. May 04)
along with the current months' (e.g. June 04) results and
avgs.
Sorry for not being so clear before.
-----Original Message-----
So, What is the question?
I think you'll be looking at grouping with group footers
and using < Average([YourField]]) >
Post back if you have a more specific question.
Fons
-----Original Message-----
I would like to display the previous months averages while
showing the current months results and averages.
.
.
.
 

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

Similar Threads

Column Calculations 101 1
vba 0
Average 10
Avereging the Subtotals in Reports 1
Excel Sumproduct 0
Average of Subtotals in Pivot Table 0
getting an average on the "Count" in a report summary 2
Sorting graph columns 6

Back
Top