Display alternate column in a query

[zero3ree]

I think this should be easy but I can't figure it out. I am using the Desktop Project Management template in Access and want to change a Open Project query from displaying the "id" which is a number, to the name column. In the projects table the field is set to number which is in a relationship with the employees table. Without changing any of that is there a way to run a query that will display the name instead of the number?



Thank you in advance.

[ranman256]

in the current query, delete the field ID off the grid
dbl-click NAME field in the table and it will appear in the query grid.
now run it.

[June7]

Make sure both tables are included in the query and linked on the PK/FK fields.

[zero3ree]

Thank you both for your responses. I got pulled away to meetings for the rest of the day so I will try this tomorrow

[zero3ree]

I made some images to explain this better. This is my query

As you can see the Project, Assigned To show up as text. Project Lead was added to the query from the projects table and you can see it came in as a number not text.

This is a connection to the query within excel. As you can see here they all changed to numbers. I know the actual field in the table says its a number for relationship reasons but how do I get them to display as text?

[June7]

What table has the people names? Include that table in the query and link on the related Lead ID PK/FK fields between that table and Projects table. Pull the name field(s) from people table into the query grid.

[zero3ree]

That worked! Thanks for your help.