Summing query totals together (1 Viewer)

[Dannyc989]

Hi folks,

Not to sure if this is the right topic to post in but I'm 80% sure it is... I have a number of querys which search by month and year, I want to be able to sum up 3 of the querys together and display this in a text box on a form... I have tried dsum etc but I can't seem to do it...

So basically I want the totals which are dsumed into the same form to calculate together in a different query if required... This would be simple except one of the months if from the previous year...

Any help is most appreciated as always...

 

[plog]

When you tried to do this with DSum, what did the expression look like? What did it show and what did you expect it to show?

 

[Uncle Gizmo]

This would be simple except one of the months if from the previous year.....

Is the previous year a different table?