Report showing "ID" not name

[Melanie_H]

I have an Employee Table with the employee's ID, FullName, etc.

I then have a table that pulls in the Employees Name, then they schedule after that with times, etc.

I then created a query to pull each employees name, then their schedule for a specific date.

Then, from the query, I made a report. The report shows Employee, then their schedule. Problem is, it's pulling the employees "ID", rather than their name. (In the query, above it is pulling their name to be shown.)

How do I make it show the employees name rather than their ID?

Thanks.

 

[MSAccessRookie]

I have an Employee Table with the employee's ID, FullName, etc.

I then have a table that pulls in the Employees Name, then they schedule after that with times, etc.

I then created a query to pull each employees name, then their schedule for a specific date.

Then, from the query, I made a report. The report shows Employee, then their schedule. Problem is, it's pulling the employees "ID", rather than their name. (In the query, above it is pulling their name to be shown.)

How do I make it show the employees name rather than their ID?

Thanks.

I am not sure you supplied enough information to provide a definitive answer, but I do have a suggestion that is based on my previous experience. You may already have selected the proper information to display, but the Report may not know how to display it.

Check the Row Source, Column Widths, and Bound Column on the Properties of the Field that represents the Employee Name. They should look something like this:

[FONT=Courier New]Row Source:      (Data selected from your Table).    [/FONT][FONT=Courier New]Select EmployeeID, EmployeeName From Employees[/FONT]
[FONT=Courier New]Column Widths:   (For display on the screen).        [/FONT][FONT=Courier New]1";0"[/FONT]
[FONT=Courier New]Bound Column:    (Primary Key for the Row Source).   [/FONT][FONT=Courier New]1[/FONT]

The example Selects the EmployeeID and the EmployeeName, but only the EmployeeID is displayed because the width of the EmployeeName display area is 0 (Column Widths 1";0"). Switching the values to (Column Widths 0";1") will hide the EmployeeID and display the EmployeeName. You may need to widen the field to greater than 1" to display the whole name.

If this does not work for you, please try to post the Row Source, Column Widths, and Bound Column from the Properties of the Field that represents the Employee Name, and we can try to help out.

 

[Rich]

Assuming that the Report is based on the query that displays the actual name make sure you have that field on the report and not the ID

 

[Melanie_H]

Here is my report:
The employee field is in the header so the report can group by employee. (I'm not seeing any option to change the bound column)

 

[Melanie_H]

Picture of query items

 

[Scooterbug]

Is the field for Employee in your Schedule Table a Lookup Field?

 

[Melanie_H]

No the field is not a lookup field. (WRONG! my bad!)

 

[Melanie_H]

The field in the schedule table is a lookup field for the employees.

 

[Scooterbug]

Hmmm....looking at your picture of the your query, there is a drop down field for the Employee name....but in the QBE, there is only the Schedule Table. Are you sure that it's not a lookup field?

Open up the table in design mode and go to the Employee Field. Click on the tab labeled "Lookup". What does it say?

 

[Scooterbug]

That is your problem then. The actual value that is stored in the field is a number, which is why you are getting the ID number. Lookups at table level are evil. A search for the evils of Table Level Lookups here on the forums will give you plenty of information why.

To fix your problem, create a table:

tblEmployees
EmployeeID
EmployeeName

Set the Employee to Autonumber, and add your employees so that the ID in the table is the same as the Employee name.

In the query, add tblEmployees and link the EmployeeID from tblEmployees to the Employee Field in Schedule. You can then add the EmployeeName to the query and used that as the control source for the Employee on the report.

 

[Melanie_H]

Thanks, I'll try that.

Appreciated!

 

[Melanie_H]

Is the Employee ID set to Autonumber? I can't set the name.
I'm just confused on when it says "set the Employee" to autonumber.... on the table... is that the EmployeeID?

Thanks.
Melanie

 

[Scooterbug]

Is the Employee ID set to Autonumber? I can't set the name.
I'm just confused on when it says "set the Employee" to autonumber.... on the table... is that the EmployeeID?

Thanks.
Melanie

Yes, my bad. The EmployeeID should be autonumber, this way you know that if you add more in the future that you dont wind up with duplicate ID numbers.

 

[Melanie_H]

Employee ID is autonumber (so that will do it, itself)
Employee Name is employee's name.....

How do I "add your employees so that the ID in the table is the same as the Employee name"???

(I'm confused for some reason.... thanks for the help.)

 

[Scooterbug]

What you want to do is to recreate the Employee Table so that the data in it is identical to what you already have stored. So, for example, in your posted picture, you have an employee named Tara Johnson. She already has an ID number assigned to her and it's stored in a pre exsisting table. When you put the Employees into the Employee table, you want to make sure that the number that is already assigned to her matches up with the number in the new Employee Table. This way you dont need to go and update records.