criteria for report

[Ann]

I have a report that shows all employee data for all employees. What would be
the best way to take that report and create a new report that only shows an
individual employees info. For example, enter your name and/or id and the
report shows all your info but you can't see anyone elses.

Thanks

 

[Maurice]

Hi Ann,

If you open the report from a form you could use a button. You could then
enter the criteria to a specific record like:

DoCmd.openreport "your reportname",,"EmployeeID= " & me.employeeID

Assuming you have a field called EmployeeID.

You can also use a combobox with all the names of the employees. Create a
query from your employees table

EmployeeID, EmployeeName

This way use the query as the controlsource for your combobox. When the user
chooses a name then you can still use the button as mentioned earlier but in
that case you can reference to the combobox:

DoCmd.openReport "yourreportname",,"EmployeeID= " & me.comboboxname

replace the yournames for your own controlnames.

hth