Help needed with Access 2000 Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working w/ an existing database. In this database there are about 300
employees. I created a report to print envelopes based on fields of their
personal infomration. However, the report (envelope) prints for all
employees, not just the one I am currently on. Is there a way I can only have
the report filtered for the one employee (with out having to change it every
time?) - THIS IS FOR ACCESS 2000.
 
Base your report on a query that pulls in the fields you need, and put a
parameter on a non-repeating field - probably your primary key.
For instance, you may have a field for social security number, or some sort
of employee ID. Pull that into your query. In the Criteria field, type [Type
the Employee ID in here] or something like that. It's called a parameter
query, but what it really does is fool Access into thinking this is a field
because of the square brackets. When you run the query, Access will ask you
what you mean by [Type the Employee ID in here], and you type in the correct
ID number. It will then only pull that one record.
Now go back to your report and change your fields to pull from this new
query instead. No need to pull in the employee ID field into your report -
you can pick and choose which of the query fields you want to appear.
 
Back
Top