Hello all,
I'm working on getting my organization's budget set up in access 2007 and have run into a problem that I'm hoping one of you can help me with.
We have different divisions which contain multiple programs. Each of these programs has there own accounts. For instance there is an electricity account that all programs will have. So in my tables I'm going to have the following fields:
Division
Program
Account
Budget
What I need is a division report. That would have to add up multiple budgets for an account (for example electricity) for all the programs contained within that division. So for example if division = 1 and account = 100 then SUM budget for all entries that match those criteria.
How does one do this kind of calculated If/Then statement in a report.
Thanks very much.
I'm working on getting my organization's budget set up in access 2007 and have run into a problem that I'm hoping one of you can help me with.
We have different divisions which contain multiple programs. Each of these programs has there own accounts. For instance there is an electricity account that all programs will have. So in my tables I'm going to have the following fields:
Division
Program
Account
Budget
What I need is a division report. That would have to add up multiple budgets for an account (for example electricity) for all the programs contained within that division. So for example if division = 1 and account = 100 then SUM budget for all entries that match those criteria.
How does one do this kind of calculated If/Then statement in a report.
Thanks very much.
