Setting a Control with an Iif Statement 1

[Boots6]

This is on a report not a form, but hopefully someone can help me. I have a report that has fields: NAME, CLASSIFICATION, and WAGE. The report's Record Source is a Query called qryDISTRIBUTION. I want the WAGE field to be blank if the the CLASSIFICATION = "Superintendent"

I tried setting the WAGE control source to =Iif([CLASSIFICATION] = "Superintendent",Null,[WAGE]) but I'm getting an error because it's a circular reference. How can I better go about this?

Thanks!

 

[MacroScope]

Try being specific. [Reports]![ReportName]![Classification] and [Reports]![ReportName]![Wage]. You can also use [Screen].[ActiveReport] instead of [Reports]![ReportName] if you prefer.

 

[dhookom]

I see a couple possible issues. First you used "NAME" as the name of a field. IMO, don't ever use reserved words to name anything particularly "NAME".

Next, is it possible the name of your text box is CLASSIFICATION or WAGE? This would create a circular reference.

Duane
Hook'D on Access
MS Access MVP

 

[Boots6]

Thank you both for the reply! My text box was named WAGE and that was the problem - thanks so much!! I don't really have "NAME" as a field, I was just trying to be brief. I really appreaciate the help.

 

[dhookom]

Boots6,
Please do everyone a favor and don't use reserved words even to be brief ;-)

Duane
Hook'D on Access
MS Access MVP