Show info from other table in report

  • Thread starter Thread starter Daniel G.
  • Start date Start date
D

Daniel G.

I made a report based off of one table. In this WorkOrder
table I have a field EmployeeID(1,2,3...), which is tied
to the Employee table and it returns the Employee Name.
However when I created a report, when placing the
EmployeeID field in the report, it returns the EmployeeID
Number and not their name. How can I have the report
return their name, which is in a different table? Do I
create a query, macro? I need some help here and its
driving me nuts...thanks for you all your help
 
Open the record source of the report and add the Employee table. Add a join
line between the EMployeeID fields. Add the Employee name fields to the
grid. Close the query and update. This allows you to use the employee name
rather than the ID.
 
Back
Top