Search results

I know this is old, but reading Pat's response made me second guess using DSum. I did some searching and as he suggested, there is a way to avoid using it. You can execute a running totals query and avoid the aggregate function like this (used in MS Access): SELECT Sum(a2.Sales) AS SumOfSales...

Is it possible to query for example the average of a value given multiple conditions in time? Like: Average value for 1st Qtr, 2nd Qtr, and so on in one single query? I know how to execute a query for one quarter, but this goes for several years and the query count gets excessive. One...