Show text instead of ID

[Guest]

Hello,

On my report, I have it showing some pulled data from a table (separate from
the employee table) with different employees. It is showing the unique
employee ID (which is how it is correctly stored, I know), but is there
anyway to show the employee name text on the just the reports instead of the
ID without changing how it is stored in the data table?

So for my sake, it shows "1" on the report, but I'd rather have it show "Sam".

 

[Rick Brandt]

Hello,

On my report, I have it showing some pulled data from a table
(separate from the employee table) with different employees. It is
showing the unique employee ID (which is how it is correctly stored,
I know), but is there anyway to show the employee name text on the
just the reports instead of the ID without changing how it is stored
in the data table?

So for my sake, it shows "1" on the report, but I'd rather have it
show "Sam".

Assuming that the text is stored in another table then simply add that table to
the Report's query and use that field in your ControlSource instead of the one
with the ID.

 

[Guest]

But in each table the employee could/will be different for each instance
shown in the report. Changing it to show the employee table wouldn't change
each field to the correct employee, correct?

 

[Guest]

Are you suggesting you have more than one employee ID field in the report's
record source? If so, include the employee table multiple times.

 

[Rick Brandt]

But in each table the employee could/will be different for each
instance shown in the report. Changing it to show the employee table
wouldn't change each field to the correct employee, correct?

Well, you need to create a join between the two tables in the query on the
related fields. That will tell the query that "this text goes with this ID".