Sum Subform

[flavi]

Hey quick and easy question. I am able to sum the subform, but I have 2 fields called txtSHIPAMT and txtTAXAMT, which may be $0.00 alot. I am trying to sum the subform and only sum the ship and tax fields when they have totals in them. Do you have any suggestions?

Thanks

Here is a picture and a the code that I am currently using:

=Sum(Nz([fldTAXAMT]+[fldSHIPAMT]+[frmONE].[Form]![txtSUM],0))

 

[HiTechCoach]

Try:

=Nz([fldTAXAMT],0)+NZ([fldSHIPAMT],0)+NZ([frmONE].[Form]![txtSUM],0))