If Function

[loquinn]

I am trying to enter an If statement. Can you please help me with this
statement for Price per acre:

‘IIf([MitigationBank]="LCPMB",(“17500")),(IIf([MitigationBank]="WBJMB",("15000")))'

If the bank is LCPMB the price per acre is 17500 if it is WBJMB it is 15000.
In my query i have created a Calculated field to equal AcresPurchased *
PricePerAcre

 

[Beetle]

Answered in the other thread you started. It's not necessary
to repost unless you've gone a day or two without an answer.

 

[Wayne-I-M]

Or

(But I think you need a quoted cost table and a linking table but up to you)

Something:
[TableName]![AcresPurchased]*IIf([TableName]![MitigationBank]="LCPMB",17500,1500)