Add all choice (1 Viewer)

[asp_learner]

Hi,

I have a query with two criterias.

The first one is by Company and the second is by type.(monitored or not monitored). I want to be able to give three choices for the second criteria, monitored, not monitored or all. I tried using an IIF statement, if monitored is null, value is * but it gives me everything.
I also tried the Listall solution in the solutions.mdb file but am having trouble wth that as well. I figured there has got to be an easier way.
Can you help?
Eva

 

[Alexandre]

Have a look to: http://www.mvps.org/access/forms/frm0043.htm
Re-post if still no chance.

Alex