how to sum totals and order them by month?

[killerwhale65]

hi,

i have a query that calculates totals per month.

I have 2 of those query's, and i would like to sum those totals once again, also sorted by month.

How should i proceed?

Thanks!

Matt

 

[Pat Hartman]

If I understand correctly, you have two separate recordsets that you want to sum together. To do that requires two more queries. Make a union query to get the two recordsets into a single recordset. Then make a totals query to sum the union query.

 

[killerwhale65]

ok, but what if i dont want to sum but substract those totals? i think this wont work then?

 

[Pat Hartman]

It is not clear to me whether you want to UNION the two recordsets or JOIN them. The results will be very different. The JOIN, assuming the records contain EXACTLY the same domain, will allow you to subtract a vale in one recordset with its corresponding value in the other recordset.

 

[killerwhale65]

hi, i found a very easy way:
make a new query based on the 2 others mentioned above, and then in the field i type this formula:
totaalsom: [inBalans BTW in]-[uitBalans BTW in]

this works for me!

thanks!