Sum in Tabular Forms

mousemat

Completely Self Taught
Local time
Today, 07:15
Joined
Nov 25, 2002
Messages
233
I have a tabular form which displays records from the table.

How can I have a sum for each line of the form (basically a sum for each record?)

I have tried =sum([field1] + [field2] + [field3]) which works correctly if there is only one record showing on the form, but when there are more than one record on form the calcualtion adds everying up and places the same value in each of the calculated fields

here is a screen shot of what i'm talking about
 

Attachments

Thanks Rich

Sometimes Access is such hard work!
 

Users who are viewing this thread

Back
Top Bottom