soupisgood84
Technical User
Here is the situation....
I have a report that gets data from a query from one table. In the report it displays:
Date, Item Description, Department Name and Price.
The report is divided by department and in the footer I have the Price totaled for each.
In another table I have the projected spending limit for each department.
What I would like the report to do is:
Display the projected amount for each department, subtract the actual amount spent, then give me an amount remaining.
Any ideas......thanks in advance
I have a report that gets data from a query from one table. In the report it displays:
Date, Item Description, Department Name and Price.
The report is divided by department and in the footer I have the Price totaled for each.
In another table I have the projected spending limit for each department.
What I would like the report to do is:
Display the projected amount for each department, subtract the actual amount spent, then give me an amount remaining.
Any ideas......thanks in advance