Al,
Your question is a bit too "broad" for a comprehensive response as to the
complete process for producing this report, but I'll try to get you going on
the first step... a Parameter Query. *Check out Parameter Queries in
Help.*
Your report has a query behind it. That query determines what records
will be output to the report.
You'll need to create a "parameter" query that will allow the user to
enter information (ex. EmployeeID), and the query will use that value as a
criteria to filter out all the other employees except the one indicated.
I'll be referring to [EmployeeID], but use whatever field you're using
that distinctly identifies one employee from another. (your employee table
Key field)
Using the query design grid, place this Criteria in the column for your
EmployeeID field...
=[Enter Employee ID]
When you open the report, the query will run, the user will be prompted
to "Enter Employee ID", the user will enter an EmployeeID, and records
delivered to the report will be "filtered" by that value. Only 1 employee
should be returned.
If you need assistance after that, try a new post to continue the
process.
hth
Al Camp
