Access 2000 Expressions

[B. Sharp]

I have a expressions formula that I need to update. I tried to add into the
expressions equation and the answer is wrong .
The old equation was =[Sub-Total] *[Tax Rate]*.01 and this formula worked
perfect.
The new formula that I can't seem to fix: =[Sub-Total]+[Delivery]*[Tax
Rate]*.01. I have been trying to fix this problem for a while now.

Thank you

 

[Bill Edwards]

=([Sub-Total]+[Delivery])*[TaxRate]*.01

 

[Jeff Boyce]

If there's a chance any of your fields could contain a Null, you'll need to
include a way to handle that in your expression. Take a look at the Nz()
function.

Regards

Jeff Boyce
<Access MVP>