Calculating Avg for Date Range

R

Rebecca Ford

I have a created a table. I want to get the "average" for
a certain range of dates that I have data entered for. I
created a query...in the criteria section added my date
parameters. In totals, I selected "avg". The query
returns the avg for each date...not the date range (like
3/1/04 to 3/15/04). How do I get just the average for
those date ranges? Not the exact dates? TIA!!!
Rebecca Ford
[email protected]
 
G

Gerald Stanley

I am guessing that you have included the 'date' column in
the select and group by statements. If so, uncheck it and
you should be fine.

Hope This Helps
Gerald Stanley MCSD
 
J

John Spencer (MVP)

The SQL statement would look like
SELECT Avg(SomeField) as AverageOfSomeField
FROM SomeTable
WHERE TheDateField Between #3/1/04# and #3/15/04#

In the grid
Field: SomeField
Total: Avg

Field: DateField
Criteria: Between #3/1/04# and #3/15/04#
Show: <Not Checked>
 
G

Guest

thanks all!
-----Original Message-----

The SQL statement would look like
SELECT Avg(SomeField) as AverageOfSomeField
FROM SomeTable
WHERE TheDateField Between #3/1/04# and #3/15/04#

In the grid
Field: SomeField
Total: Avg

Field: DateField
Criteria: Between #3/1/04# and #3/15/04#
Show: <Not Checked>



.
Click to expand...
 
Top