Expression Builder

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

Guest

I'm trying to build a IIf function within a report, all I want it to do is if
the cell under column A is Yes, show nothing in the cell on the report and if
the cell under column A is No, then show N/A in the cell on the report. So I
typed:
=IIf([A]="Yes", " ", "N/A") and the error shows in all cells. What am I
doing wrong?
 
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

Expression build resetting function 2
IIf in a report based on select query -- problem w/parameters 2
Help with Iif on Report 4
Display Grid 1
Excel VBA 1
Need help with access expression - HELP!! 0
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
VBA set thick borders around non empty cells in range 0

Back
Top