Expression in Control giving error

  • Thread starter Thread starter Jodith
  • Start date Start date
J

Jodith

Actually, it's two problems.

I entered this expression: =IIf([Personnel File
Discrepancies]![PAF]="No","PAF","")
in a control. When I run the report, it's popping up a parameter input
window, and then where the control is on the report all I get is #error.

I'm seriously scratching my head. Anyone have any ideas? I used the
expression builder to come up with the expression.
 
Why are you including a table name in the expression? Is [Personnel File
Discrepancies] a table name in your report's record source? Is PAF a field in
your field list? Have you tried:
=IIf([PAF]="No","PAF",Null)
 
Back
Top