IIf works in query but not in report

  • Follow


Does the IIf function work differently in queries from the way it works in 
reports?

For example, this works in a query: 

lastName: IIf([Last]="Smith",Null,([Last]))

(I can hid the last name "Smith" in the lastName field.)

However, I cannot use the same IIf as a control source in a report.  It 
generates a circular reference error message.

= IIf([Last]="Smith",Null,([Last]))

(If the name is not "Smith", then print it.)

Is this just how IIf works?
0
Reply Utf 6/7/2010 10:30:37 PM


0 Replies
461 Views

(page loaded in 0.047 seconds)

Similiar Articles:
















7/22/2012 2:28:38 PM


Reply: