Averaging data using number of days as denominator

[charliec]

I have data for the month of August and want to compare averages for 3 days prior an event and 3 days post. How do I program such that Access looks at a start date and uses 3 days prior than and then 3 days post.

Thanks.

 

[jjonesal]

Need a little more info...are you trying to do this in a query? What do your tables look like? J. Jones
jjones@cybrtyme.com

 

[wemeier]

If each date is in a separate record, you could use the AVG Domain Aggregate function:

Average = DAvg("field to average","table to average","recorddate Between #" & StartDate - 3 & "# And #" & StartDate + 3 & "#&quot