Need average monthly amount in report.

[Ron Weaver]

I posted something simular to this a couple of days ago, but it was very
confusing to say the least. I will try to make it more clear. I have a report
with a field of transaction dates, and a field with amounts for those dates.
My problem: How do you calculate a monthly average for those amounts when
there are multible transactions in a given month?? I hope this makes some
sense to somebody. If so, I sure would like some help.

 

[Duane Hookom]

If you want to see both the transactions and the monthly totals, group your
report by month and add a text box in the group footer with a control source
llike:
=Avg([those amounts])

 

[Ron Weaver]

Thanks Duane. I will give that a try.

If you want to see both the transactions and the monthly totals, group your
report by month and add a text box in the group footer with a control source
llike:
=Avg([those amounts])

--
Duane Hookom
MS Access MVP

I posted something simular to this a couple of days ago, but it was very
confusing to say the least. I will try to make it more clear. I have a
report
with a field of transaction dates, and a field with amounts for those
dates.
My problem: How do you calculate a monthly average for those amounts when
there are multible transactions in a given month?? I hope this makes some
sense to somebody. If so, I sure would like some help.