Exporting a query problem

[mohobrien]

I have a table that has mainly text fields and a few number fields. These number fields are simply a code to joined tables that contain repetitive text. I want to export the data with the text instead of the number code. The query runs fine and has the text where it should be but the export just has the number. It's been a while since I've used Access. I'm probably just forgetting something basic. Any hints?

 

[Jon K]

In query Design View, build a new query using the main table and the text tables. Join the tables by linking the proper fields between the main table and each text table.

Drag the text fields from the main table and the text tables to the columns in the query grid.
.

 

[mohobrien]

Thank you,
it has been a while