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

IIF Statements and filtering

P: 34
Hi, hope you can help me with this.

I am using the following IIF statement in a query to filter out data. I need to filter by site: a, b, c, or No Filter (where No Filter returns all data).

IIf([Forms]![frm FVQ main]![Site]="No Filter",Is Not Null,[Forms]![frm FVQ main]![Site])

[Forms]![frm FVQ main]![Site] is a combo box where 'No Filter' is one of the options. When someone selects 'No Filter' i need to return data from all sites. I thought that using 'Is not Null' would return all data but unfortunately it does not.

Hopefully there is an easy solution to this, however i am lost.

I am using Access '97.

Thanks in advance
May 30 '07 #1
Share this Question
Share on Google+
2 Replies

puppydogbuddy
Expert 100+
P: 1,923
Hi, hope you can help me with this.

I am using the following IIF statement in a query to filter out data. I need to filter by site: a, b, c, or No Filter (where No Filter returns all data).

IIf([Forms]![frm FVQ main]![Site]="No Filter",Is Not Null,[Forms]![frm FVQ main]![Site])

[Forms]![frm FVQ main]![Site] is a combo box where 'No Filter' is one of the options. When someone selects 'No Filter' i need to return data from all sites. I thought that using 'Is not Null' would return all data but unfortunately it does not.

Hopefully there is an easy solution to this, however i am lost.

I am using Access '97.

Thanks in advance
Your "NoFilter" selection has no site association, and therefore, is commonly referred to as the "extra row" that needs to specially handled as described in this thread. http://www.thescripts.com/forum/thread652627.html
May 30 '07 #2

P: 34
Thank you very much !!
May 30 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.