Calculate total for single row

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
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple SUM: 3 columns – error 4
Totalling Selected Sums 4
Find Bad Debtors: Show select data from query 6
Subform Datasheet Total Row 3
Refrencing Totals Row in datasheet 1
After Update event does not fire when pasting multiple rows intosubform datasheet view 1
Total Row in datasheet view has problems if using ADP / SQL 4
Disappearing records in datasheet view 1

Top