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
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