I have a report that opens a dialog box for input. Dialog box contains one combo box that lists all employees, and two text/date boxes (StartDate and EndDate). Based on that input, report shows records for chosen employee (based on EmployeeID) and displays timesheets that fit the StartDate/EndDate criteria.

I based this report on a query and it works fine.

Now I want the same report to show records for all employees when I leave the combo box empty, and open timesheets based only on StartDate/EndDate criteria.

I think I'm suppose to put something in the or: field bellow Criteria: , but not sure what. Currently, criteria is set to read the EmployeeID from the combox box.

Could anybody give me any pointers?

the technique you need is the same described here: http://www.access-programmers.co.uk/forums/showthread.php?t=183254

please read it.

Thanks, that worked.

sure thing...