How do I create a select YTD query that totals monthly summaries?

E

eksheare

I have joined my monthly queries and created the following type of expression
for each field however this query has become cumbersome and stopped returning
accurate totals. How can I calculate YTD totals from monthly summarized data
in a more efficient manner?
 
T

Tee

to eksheare: your sample code just saved me - I was summing three fields, but
did not include the NZ function. THANK YOU!!!!
 
Top