Calculate total for single row

  • Thread starter Thread starter Confused87
  • Start date Start date
C

Confused87

I need to chart totals for the funds the charity I worl for recieves.

I have one record per Event with an ID, I then have Funds Recieved 1, Funds
Recieved 2, et cetera.

I have a subform in my Member Profile which lists all events in datasheet
view and I can calculate a total for all the events for one member, however I
need to do this for each individual event (aka record aka row) preferebly in
the subform datasheet view, but I'll settle for form view if this is not
possible.

Many Thanks
 
Your database is laid out wrong. You should have a separate record for each
contribution.
But to total as you have it now use this --
Contribution: Nz([Funds Recieved 1]) + Nz([Funds Recieved 2]) +
Nz(([Funds Recieved 3]) + ... for as many as you have.
 
Back
Top