J
Jen
I have a database used to record invoices (vendor, date, number, service
period beginning and end, amount, etc.). My report shows the records for a
specific time frame. (In the database, the service period is entered as:
SvPeriod: 1/01/2008, SvPeriodEnd: 1/31/2008.) The records are grouped by
vendor and then by service period. However, when creating the report, I
chose to use SvPeriod by Month, in which case Access turned the SvPeriod date
into the actual month and year and created the "SvPeriod by Month" field.
(For example, it took 1/01/2008 and created January 2008.) Each vendor has
anywhere from one to four SvPeriod by Month groupings. What I need to do is
to calculate the total invoice amount per vendor divided by the number of
service periods to get the average total invoice amount per month. Please
help.
period beginning and end, amount, etc.). My report shows the records for a
specific time frame. (In the database, the service period is entered as:
SvPeriod: 1/01/2008, SvPeriodEnd: 1/31/2008.) The records are grouped by
vendor and then by service period. However, when creating the report, I
chose to use SvPeriod by Month, in which case Access turned the SvPeriod date
into the actual month and year and created the "SvPeriod by Month" field.
(For example, it took 1/01/2008 and created January 2008.) Each vendor has
anywhere from one to four SvPeriod by Month groupings. What I need to do is
to calculate the total invoice amount per vendor divided by the number of
service periods to get the average total invoice amount per month. Please
help.