Count and average (1 Viewer)

[mugman17]

I have a query where I need to see how many times the same delivery location appears between 2 dates. Then I need to average that. Any ideas? The dates are plugged in from a user through a form.

 

[David R]

Average it with what, itself?

I used two Totals queries:
1st Query:
DeliveryLocation, Group By
DeliveryLocation, Count
DateField, Where, Criteria: Between Forms.FormName.StartDate And Forms.FormName.EndDate

2nd Query:
CountOfDeliveryLocation, Avg.

[This message has been edited by David R (edited 05-28-2002).]