Average in report

[Jeff C]

I have a report sorted first by name and then by a date with a header
and footer on each of those levels. Based on this I get subtoals and
toals nicely on additional fields that I have in the report. I now
need to get the average value on one of those fields for each
occurance in the sorted date field. Can someone offer me guidence?

Thank you

 

[Guest]

In hopes that someone might help I'll try a better explanation

I have a table of records of individuals who work several days each week at
[XRate] which can change each day they work.

The day they work falls between the [periodbeginning] date and the
[periodending] date in another table. These tables are related to each other
on the employee.

I am trying to come up with the average [Xrate] during each time period for
each individual and want to do it with a query.

Thanks in advance.

 

[Jeff C]

I have a report sorted first by name and then by a date with a header
and footer on each of those levels. Based on this I get subtoals and
toals nicely on additional fields that I have in the report. I now
need to get the average value on one of those fields for each
occurance in the sorted date field. Can someone offer me guidence?

Thank you

Still fighting with this, heading really should be "isolating and
average value in query"

The way I need to use the value I really need to come up with it in a
query field. Can anone offer assistance?