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.
 
Back
Top