inserting running totals

  • Thread starter Thread starter ned
  • Start date Start date
N

ned

working for a school and need to update the resources
spending interface.
2 tables
"BT" each departments budget (2 rows Department and Budget
in£)
"DT" spending table (data entered dept/date/type of
service/cost in £)

on the data entry page for new service charges i need a
running total of the amount of money left in the
departments budget.
entry screen updates the "DT" table, so once you select
the department from the dropdown i need it to :-
SUM (specific departments)COSTs
then
TOTAL (specific departments)Budget- (specific departments)
TOTAL COSTS

tried everything and unfortunately no luck as im no
expert. any one know how to run this full query as a
simple text box showing a remaining amount in account?

all help greatfully recieved.
peace
ned
 
plus when this is done how can i set say a £50 warning
signal on a department to cause a formatted warning letter
to print out.
so if while i input a bill for Science and it sees that
they only have £40 left it would automatically print a
small letter out warning the department it is close to its
bugetry limit.

all/any help welcomed.
peace
ned
 
Back
Top