Hello all,
I'm trying to update my organization's budget into access and I've ran into a problem with the reporting.
In my main table there are the following fields:
Division #
Account #
Program #
Budget
Any given division will have multiple programs within it, and any given program will have the same accounts as other programs (all programs have salaries for example).
What I'm having trouble with is designing a query/report to report on divisional totals. So if I have division 1 with 3 programs, when I run the report on division 1 I want it to show me the total for each account # (salaries for example) instead of the 3 separate entries for each program.
Would I be using DSum in a query to do this? What would that look like?
Thank you for the help.
I'm trying to update my organization's budget into access and I've ran into a problem with the reporting.
In my main table there are the following fields:
Division #
Account #
Program #
Budget
Any given division will have multiple programs within it, and any given program will have the same accounts as other programs (all programs have salaries for example).
What I'm having trouble with is designing a query/report to report on divisional totals. So if I have division 1 with 3 programs, when I run the report on division 1 I want it to show me the total for each account # (salaries for example) instead of the 3 separate entries for each program.
Would I be using DSum in a query to do this? What would that look like?
Thank you for the help.
