Total field

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

Guest

Hi all

I have a field with the expression...=[Charge 1]+[Charge 2]+[Charge 3]+[Fuel Surcharge]..called it "Net Charge

I have created a text box in the header to total all the records in thr Net Charge field and have the expression....=SUM([Net Charge]) but it shows as zero, if I only have one record it gives the total for that record, but as soon as I enter a 2nd record it reverts to zero

Any ideas

Al
 
Try

=SUM(Charge 1]+[Charge 2]+[Charge 3]+[Fuel Surcharge])

hth

Chris
-----Original Message-----
Hi all,

I have a field with the expression...=[Charge 1]+[Charge
Click to expand...
2]+[Charge 3]+[Fuel Surcharge]..called it "Net Charge"
I have created a text box in the header to total all the
Click to expand...
records in thr Net Charge field and have the
expression....=SUM([Net Charge]) but it shows as zero, if
I only have one record it gives the total for that record,
but as soon as I enter a 2nd record it reverts to zero.
 
Hi

Try the following:

=NZ([Charge 1],0) + NZ([Charge 2],0) ...

Maurice

I have a field with the expression...=[Charge 1]+[Charge 2]+[Charge 3]+[Fuel
Surcharge]..called it "Net Charge"
 
Back
Top