IIF statements

[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

 

[Sambantham Kuppusamy]

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