calculate fields in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get the sum of several fields,for each record in a form.
I have put this in the form footer:
=sum(Nz([scrip1])+Nz([scrip2])+Nz([etc.]))
This calculates the record, but the sum is now in everyones record, and when
i add any amout to the next record (just to see what happens) it keeps adding
to the calculated amount. Can someone please help. I am extremely new at this.
thanks,
renee
 
If you want the text box in the Form Footer to show just the total of the
selected row, drop the Sum(), i.e.:
=Nz([scrip1],0)+Nz([scrip2],0)+Nz([etc.].,0)

If you want that value to show up in every row, place the text box in the
Detail section instead of the form footer.
 
Back
Top