Showing ID number not required text

[Nikki]

Hi,

I have created a report with data grouped by employee. When I look at the
report it has the ID number of the employee instead of the name. How do I
get it to show the name like it does on the form?

Nikki

 

[Marshall Barton]

I have created a report with data grouped by employee. When I look at the
report it has the ID number of the employee instead of the name. How do I
get it to show the name like it does on the form?

It sounds like the dreaded Lookup Fields has struck again?

Modify the report's record source query to include the
employees table joined on the employee ID field. Then you
can add the employee name field to the query's field list
fpr the repprt to use.

If that's not appropriate, post details about the tables and
fields that are involved.