K
Kerry
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!
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!