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

"Select all" in IIF-function

P: n/a
Does anybody have any advice on selecting all records within a
iif-statement?

I have a form in which one has to state if all projects or just a
selection of projects are to be used for a query. If "all projects" are
required the query should show all records.
In the example below the iif-statement should select all projects or
just "projectnumber 2".

I tried the following as criteria but none is working:

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all projects",Is
Null,"projectnumber 2")

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all projects",like
"*","projectnumber 2")

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all
projects",*,"projectnumber 2")

Any suggestions on this?

Thanks in advance,
Rene

Sep 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
This should work

Like IIf([Forms]![F_Quantities]![ProjSelOrAll]="all
projects","*","projectnumber 2")

<bh****@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Does anybody have any advice on selecting all records within a
iif-statement?

I have a form in which one has to state if all projects or just a
selection of projects are to be used for a query. If "all projects" are
required the query should show all records.
In the example below the iif-statement should select all projects or
just "projectnumber 2".

I tried the following as criteria but none is working:

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all projects",Is
Null,"projectnumber 2")

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all projects",like
"*","projectnumber 2")

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all
projects",*,"projectnumber 2")

Any suggestions on this?

Thanks in advance,
Rene


----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Sep 14 '06 #2

P: n/a
Hi Martin,

It's working! Thanks a lot!

Cheers,
Rene
Martin schreef:
This should work

Like IIf([Forms]![F_Quantities]![ProjSelOrAll]="all
projects","*","projectnumber 2")

<bh****@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Does anybody have any advice on selecting all records within a
iif-statement?

I have a form in which one has to state if all projects or just a
selection of projects are to be used for a query. If "all projects" are
required the query should show all records.
In the example below the iif-statement should select all projects or
just "projectnumber 2".

I tried the following as criteria but none is working:

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all projects",Is
Null,"projectnumber 2")

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all projects",like
"*","projectnumber 2")

IIf([Forms]![F_Quantities]![ProjSelOrAll]="all
projects",*,"projectnumber 2")

Any suggestions on this?

Thanks in advance,
Rene

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Sep 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.