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!