Can anyone help me with a simple IIf function?

  • Thread starter CharlesCount via AccessMonster.com
  • Start date
C

CharlesCount via AccessMonster.com

On table Reser, if field equip =AMB Eld, enter 1 if not 0

Thanks
 
D

Duane Hookom

Your question lacks sufficient detail to provide more than a WAG. Try
=IIf([Equip]="AMB Eld",1,0)
 
Q

quinto via AccessMonster.com

Duane said:
Your question lacks sufficient detail to provide more than a WAG. Try
=IIf([Equip]="AMB Eld",1,0)
On table Reser, if field equip =AMB Eld, enter 1 if not 0

Thanks


Thank you very much. That is what I needed, I was missing the quotation mark
 
Top