I have a table with a column that will only contain Yes or No. I want users to be able to run a report and specify to show either records with Yes or records with No or all records. I have a combobox limited to the choices All, Yes, and No with All as the default.
My idea to make this happen was to use the following IIF( ) in the query as criteria
The idea is if the user specifies All, use <>All as the criteria (and show everything since All is not actually stored in the table). If they choose anything other than All (Yes or No) use that as the criteria. My idea seems great but I can't get it to work. I thought that maybe I needed to somehow pass <>All with quotes as <>"All" but I can't get the IIf( ) function right.
Any help is appreciated. Thanks,