Originally Posted by
PhilS
You should take a look at the domain aggregate functions, particularly at
DAVG.
Thanks for the suggestion but your suggestion never made much difference, I amended the following
=avg(((Workers.OT_Hours)>0) AND ((Workers.workLocation)="Texas"))
to as follows:
=DAvg(("[OT_Hours]"),"Workers",("[Worklocation] = 'Texas'" and "[OT_Hours]>0")
As it doesn;'t give me the same average number that I get from ..
SELECT Avg([OT_hours]) AS AverageOT_Hours
FROM workers
WHERE (((workers.OT_Hours)>0) AND ((Workers.workLocation)="Texas"));
Many thanks for responding though!