I have a table tblDocInfo which I made a continuous form with the fields
PurchaseOrderApprovalDate and ActualDeliveryDate and primary key docID (autonumber). I have a calculated control difTargetOutputStep1 with Control Source=DateDiff("d",[PurchaseOrderApprovalDate],[ActualDeliveryDate])

I want to calculate the average of these values on the form (will be all values ActualDeliveryDate-PurchaseOrderApprovalDate for the tblDocInfo).

In summary: I have a field showing the number of days between the ActualDeliveryDate and PurchaseOrderApprovalDate. I would like the user to be able to compare this value for each docID to the average of all of the days between the ActualDeliveryDate and PurchaseOrderApprovalDate.

For some reason I am having a hard time with this....any suggestions?