Primary key displaying instead of field value?

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

Guest

Hello,
I have a rpt based on a query that lists employee type, then name, address,
etc.
All this data is coming from a query that runs successfully. Under Employee
type though, it lists the autonumber value, instead of the other column. I
need it to show the other column, not the autonumber value. Help!

John.
 
Open the query in design view - the one that feeds the report.
Add the lookup table to the query.
Drag the field from the lookup table into the grid, so it shows the text for
the type.

You should see a line joining the two tables in the upper pane of query
design. Double-click this line. Access pops up a dialog box with 3 options.
Choose the one that says:
All Employees, and any matches from ...
(This avoids skipping the employees who have no type defined.)
Save the query. Close.

Open the report in design view.
Delete the EmployeeType text box that is giving you the number.
Open the Field List (View menu).
Drag the new field (the one with the employee type text) from the Field List
onto the report where you want this text.


I'm guessing that you used the Lookup Wizard in your table. This is another
example of why we all hate this wizard. More info in this article:
The Evils of Lookup Fields in Tables
at:
http://www.mvps.org/access/lookupfields.htm
 
Back
Top