caluating formulas.

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.
 
M

Marshall Barton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Performing a calculation based on a field value 1
Using Code instead of Criteria 2
IIf statement - checking for text 1
Main Report without Data 1
Report with a Function 2
Conditional printing of records in the detail section of a report 11
Force page every 20 records. 7
question about null data 1

Top