Showing ID number not required text

N

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
 
M

Marshall Barton

Nikki said:
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?
Click to expand...


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.
 
Top