Calucation a Group for in a Query or Form

[hendersons]

I have a query and form that joins a one-to-many from two tables. In one
table I have a field "Item Type" and the options are "Emergency" or
"Permanent" as well as a "Item Amount" field. In the second table I have
three fields "Emergency Total", "Permanent Total" and "Total".

I need to have the "Emergency Total", "Permanent Total" and "Total" keep a
running total of the "Item Amount" field dependent on which option is
selected within a group of items. For example, if I select "Emergency" and
put $400.00 in the "Item Amount" in Table 1, Table 2 needs to show $400.00 in
the "Emergency Total" and update the "Total" field.

Any help is greatly appreciated.

Sharon

 

[pietlinden]

You should be able to do this in a query instead of storing calculated
information in your table. Use something like the starting balance and
then subtract... use DSUM to get the running Emergency/Permanent totals.

 

[hendersons]

I am storing my calculations in the query and not the table. I was just
trying to be clear on what I wanted but I guess I failed at that.