Report Fields

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

Guest

I have two tables with data. The first has all my employees with their info,
and the second has my computer hardware and one field that refers back to the
SSN on the employee table
I want to create a report that shows all my computer hardware with the
employee name rather than their SSN showing. How can I do this?
 
LDanix,
Use the SSN to relate employees to equipment in the query behind the report, add your
Name field to that query, place the SSN on the report so you could use it to group on if
needed, BUT just Hide it (Visible = No) and show Name instead.
You may not, but could have, 2 John Smiths in the future, so... I would still "use" SSN
on the report, but hide it.
 
Back
Top