Can anyone help me with a simple IIf function?

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

CharlesCount via AccessMonster.com

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

Thanks
 
Your question lacks sufficient detail to provide more than a WAG. Try
=IIf([Equip]="AMB Eld",1,0)
 
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
Click to expand...
Click to expand...


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using IIF to pass query criteria 3
Help needed with IIF in my query 14
IIF statement in query criteria, help! 2
nested iif function 4
IIF function qry run from 2 tables 2
IIF returning text value 6
Multiple IIf's 6
Sum(IIF statement 1

Back
Top