caluating formulas.

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

Guest

Hello can someone please help me, I'm fairly new to access and am trying to
change a formula built into a report. I'm using expression builder in the
report.

In English the calulation would look something like:

If(Supplier_Name DOES-NOT-CONTAINS 'JCA') THEN =[Text44]*0.175 ELSE 0

Essentially if the supplier contains JCA, we don't want to caluclate VAT
just place a 0 value. If the supplier does not JCA then we need to calulate
VAT.
 
Craig said:
Hello can someone please help me, I'm fairly new to access and am trying to
change a formula built into a report. I'm using expression builder in the
report.

In English the calulation would look something like:

If(Supplier_Name DOES-NOT-CONTAINS 'JCA') THEN =[Text44]*0.175 ELSE 0

Essentially if the supplier contains JCA, we don't want to caluclate VAT
just place a 0 value. If the supplier does not JCA then we need to calulate
VAT.
Click to expand...


Answered in your earlier post of this same question.
 
Back
Top