Sum in form footer

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

Guest

I have a table with a numeric field named 01. When I try to sum it with
=Sum(Nz([01])) in the footer of a continuous form it returns an error. Why
is this?

Thanks,

Steven
 
Steven,
Is [01] a calculated field on your form?
If so, let's say [01] is a calculation like
= Price * Qty
Then Sum(NZ([01])) in the footer would yield an Error.

In your query behind the form, create a calculated field like this...
LineTotal : Price * Qty
Now Price * Qty is "bound" to field name LineTotal. Place LineTotal on
your form in place of [01], and
=Sum(LineTotal)
in the footer should work.
 
Back
Top