Subtracting

[leighms]

Hi
I have 2 queries, one calculates total new members by branch by the month, the other calculates closed members by branch by the month.
they look like:
---------------Month-----month----etc
Branch Name----Total-----Total-----etc
Branch Name
Etc
is it possible to run a query that will calculate the totals by month, so it will look exactly the same as the above but will show the increase/decrease by branch by month

 

[Uncle Gizmo]

My assumption is that the columns you show named "month" are different months, like, January, February, March.... If that's the case then the structure you have chosen is not the best choice to allow you to extract data simply and easily in MS Access.

My guess is your structure resembles a previous form probably in an excel spreadsheet.

I'm sure what you want to do will be possible, however it's not the optimum way to do it, and the chances of you getting any help are slim, not because no one will want to help you, but because you are venturing into new territory, in other words you will have to design the solutions from scratch for yourself.

The alternative is to take a step back, reconsider your design, design it more optimally to take advantage of the features available in MS Access, By doing so you will be able to tap into the knowledge of those who have gone before. In other words by choosing the optimum structure you will have the advantage of "doing things" in the accepted way, and help will be more easily found.

My first suggestion would be that you read this post here:
http://msaccesshintsandtips.ning.com/profiles/blogs/excel-in-access-part-1