PC Review


Reply
Thread Tools Rate Thread

IIf works in query but not in report

 
 
ak49
Guest
Posts: n/a
 
      7th Jun 2010
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?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iif within Iif not working =?Utf-8?B?ZGdyZWVu?= Microsoft Access 3 22nd Apr 2005 02:31 AM
Report Criteria: Query works, but report doesn't call up query??? =?Utf-8?B?QkFSS0FST08=?= Microsoft Access Getting Started 4 18th Oct 2004 06:35 PM
How to convert access query IIf([Time_Enroute] Is Not Null,IIf([P. =?Utf-8?B?TnV0aGFu?= Microsoft Access Queries 2 17th Sep 2004 04:51 PM
IIF, IIF, IIF, IIF Bill Microsoft Access Queries 2 9th Jul 2004 09:40 PM
Error running query for report...but query works fine when opened separately John Microsoft Access Reports 1 21st May 2004 04:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:51 PM.