|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 10th, 2008, 04:50 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Conditional IIF question/null value
Hi! I've got a combo list in a form which I have the choices of multiple
numbers and an ALL choice (21, 22, 23, 24, ALL). I'm trying to use an IIF statement in a query to either pull in the selected number to a criteria or leave the criteria blank in the case of ALL so all data ends up in the report. IIF([Forms]![FRM_000_GET_MARKET]![Combo13]=ALL,"",[Forms]![FRM_000_GET_MARKET]![Combo13]) So, THAT doesn't work  What's the best way for me to get it? THANKS in advance for help! 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode