J
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
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