I have a form as follows
Main Form (Client Main)
Subform 1 (Client Info)
Subform 2 (Payments/Deposits)
Main Form is the Client form
subform 1 are the status and details of clients & info
subform 2 is/are the payment clients have paid to date (deposits)
subform 2 gets its data from a payment table/form which lists all payments from all clients - their account numbers posts the payments to their respective subform client info via their account number and accessID number (this works perfectly)
Now I need to add a total field to show the cumulative payments (totals) for each account number which has been derived from subform 2 and needs to appear in Main form.
A user selects the client, then clicks on the subform status by year, and then sees all info related to work for that year, I need to calculate the cumulative monies received (could be paid by 5 separate checks)
Gee I hope I explained this correctly