Can I use IIF in a report with one field as criteria, another as v

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

Guest

I am trying to create report that displays a % from a field when the value of
another field is not 6. If it is 6, I want the % field to be left blank.
 
I figured this out. I had changed the control source to the function, but
Access was confused because the name of the field was the same as one of the
criteria in the function.
 
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

Access Access Report Works on One Machine but not Another 3
Formula in report field too long 4
using iif and like in control Source of report 1
Need help with iif stmt in text box 3
Calculating a value of a field with iif rule in report 1
Report to bring back active field only 4
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Adding new fields to an old report 1

Back
Top