Access 2000 Expressions

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

Guest

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
 
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>
 
Back
Top