Query criteria question

[rainbowforest]

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?

 

[ajetrumpet]

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

please read it.

 

[rainbowforest]

Thanks, that worked.

 

[ajetrumpet]

sure thing...