If Function

  • Thread starter Thread starter loquinn
  • Start date Start date
L

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
 
Answered in the other thread you started. It's not necessary
to repost unless you've gone a day or two without an answer.
 
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)
 
Back
Top