Report Fields

L

LDanix

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?
 
A

Al Campagna

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

200KB versus 35MB 0
Report Group Footer DLookUp 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Insert Index into a Table 1
Report problem - Access 2003 7
create a custom report 1
Should I base my report on a form or a query? 2
An Opposite Report 2

Top