I am trying to develop a report where in the PartNum footer the
average number of days between orders is calculated. I have
created the following:
Table: tblItemsRecvd
Fields:
PartNum
SupplrName
DateOrdrd
DateRecd
AmtRecd

Query: qryItemsRecvd based on tblItemsRcvd
PartNum Criteria: [Enter PartNum:]
SupplrName
DateOrdrd
DateRecd
AmtRecd

Report: rptItemsRecvd based on qryItemsRecvd

I would like to calculate the average number of days between orders for
the selected part number. Do I do it in the query (how?) or at the report
level (how?)? I am using Access2003 and am a novice.
TIA

Hi,

i would do this in the query by using the DateDiff-Function.
Take a look at this link:
http://www.techonthenet.com/access/f...e/datediff.php

Regards
Jörn


Am 07.06.2010 01:49, schrieb JohnL:
> I am trying to develop a report where in the PartNum footer the
> average number of days between orders is calculated. I have
> created the following:
> Table: tblItemsRecvd
> Fields:
> PartNum
> SupplrName
> DateOrdrd
> DateRecd
> AmtRecd
>
> Query: qryItemsRecvd based on tblItemsRcvd
> PartNum Criteria: [Enter PartNum:]
> SupplrName
> DateOrdrd
> DateRecd
> AmtRecd
>
> Report: rptItemsRecvd based on qryItemsRecvd
>
> I would like to calculate the average number of days between orders for
> the selected part number. Do I do it in the query (how?) or at the report
> level (how?)? I am using Access2003 and am a novice.
> TIA
>