nested IIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this calc field:
=IIF([use process again]=1,"yes",IIF([use process again]=0,"no","")
I get the #Error on the report.
What I'm trying to do is print "yes" or "no" for a checkbox field.
tia,
 
Janis

Is the calculation performed in a query field, or in a report control?

Can you successfully perform the calculation in a query field?

Is there a chance that the checkbox has the "tri-state" property turned on
(i.e., Yes, No, null)?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

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

Option Buttons to Pass Criteria to Query 6
sum of calculated fields in header of report 1
Aggregate Function Error 0
Query Criteria IIf statement 4
Nested IIf doesn't work 18
Multiple iif challenge 2
Access My Expression Contains Wrong number of arguments 0
selecting null with an iif expression in criteria access 2k3 13

Back
Top