Total field

[Alby]

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

 

[Chris Large]

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

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.

 

[StCyrM]

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"