IIF statements

  • Thread starter Thread starter susanh
  • Start date Start date
S

susanh

I'm not quite sure how to write this in my expression
builder?...

if [Contract Amt] doesn't equal [Vendor Amt], then
[Contract Amt] minus [Vendor Amt], if they do equal then
[Contract Amt]


Can anyone help me?

Susan
 
Susan,

Try this.

Create a new query and add the required table to the query (suing add table)
Write the following code in the first colum.

ExPr1: IIF( [Contract Amt]=[Vendor Amt], [Contract Amt], [Contract Amt] -
[Vendor Amt] )

Save the query and execute.



SAM
 
Back
Top