Avg over last 3 months query

[wildti]

Hi,


I am trying to the work out the average for a column but only taking into account lines dated in the last 3 months.

this is what I have:
SELECT Avg(DaysTaken) AS Expr1, tblMain.DateOnRequest
FROM tblMain
WHERE ((DateDiff("dd",[DateOnRequest],Date())<90));




This is giving me this error :
"You tried to execute a query that does not include the specified expression 'DateOnRequest' as part of an aggregate function

Thanks in advance for your help :-)

[ranman256]

in the query , look under the field, on the TOTAL row. Its probly blank.
Set it to sum or avg or GROUP BY, but not blank.

[wildti]

Hi Thanks I cant see a "total" row. Could you point me in the right direction.