Calculating Avg for Date Range

[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
(e-mail address removed)

 

[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

 

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

 

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



.