Query Question - Refine with Criteria or Pull all records?

[jmgibson]

I have a very simple query that allows a user to pull up an employee's information by their empID.

SELECT tblEmployee.empID, tblEmployee.Name
FROM tblEmployee
WHERE (((tblEmployee.empID)=[Enter empID to list Specific Employee]));

I also would like the ability to pull all employees if the ID is not known (ideally through the same query). For instance, when the query runs, the pop-up box would ask a user for the empID, but if they left it blank, it would pull all data. Any thoughts?

 

[FancyPrairie]

I would use a form where the user could select the employee(s) they want included in the query via a single or muli-select listbox or combobox. If nothing is selected, then all would be displayed. I just explained how to do this for someone else in this thread thread702-1030820

 

[jmgibson]

Is there a way to do this with an IIF statement instead?