By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,939 Members | 1,621 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,939 IT Pros & Developers. It's quick & easy.

Using IIF; A2K/SQL2000

P: n/a
I have an A2K database with linked tables to SQL Server 2000.

I am trying to use an iif statement in a query.

IIf([forms]![frmreporting]![Associate] Is Null,
"*",[forms]![frmreporting]![Associate])

This will return records when [forms]![frmreporting]![Associate] is not null
but will not return any records when ([forms]![frmreporting]![Associate] is
null. I want to return all records when ([forms]![frmreporting]![Associate]
is null.

Also tried:
IIf([forms]![frmreporting]![Associate] Is Null,Like
"*",[forms]![frmreporting]![AssociateID]) with various combinations of singe
and double quotes.

Can anyone assist? Any workarounds?

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Terri wrote:
I have an A2K database with linked tables to SQL Server 2000.

I am trying to use an iif statement in a query.

IIf([forms]![frmreporting]![Associate] Is Null,
"*",[forms]![frmreporting]![Associate])

This will return records when [forms]![frmreporting]![Associate] is not null
but will not return any records when ([forms]![frmreporting]![Associate] is
null. I want to return all records when ([forms]![frmreporting]![Associate]
is null.

Also tried:
IIf([forms]![frmreporting]![Associate] Is Null,Like
"*",[forms]![frmreporting]![AssociateID]) with various combinations of singe
and double quotes.

Can anyone assist? Any workarounds?

Thanks

Use
IsNull(condition,true,false)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.