Calculate user totals in table one and enter values in table 2

O

osullipa

I have two tables. The first contains details of a budget holders money
allocation for a given period, and the other tracks their spend on products
over that period. How can I generate a query to calculate the total running
spend for each user from the "budget spend table" that will be written into
the users record in the "budget allocation table"?

My aim is to show details of budget allocation, total spend to date and
remaining budget for each user in an the Order form / report.

Can anyone please advise me on how to do this or suggest another way of
doing it. Any help would be greatly appreciated.

Thanks in advance.

Regards

Peter
 
Top