Exporting to Excel

B

BT

I have a table with a column that is fed by a sub-table with a auto number
primary key and another column with text. When I export a query based on the
table to Excel, the primary key is shown. How do I sow only the text
description?

thanks
 
D

Duane Hookom

Export a query that contains the field with the actual value you want to go
to Excel.
 
K

Klatuu

Include the sub-table in the query and join it to the main table on the key
field. Unclick the check box Show Field in the query for the key field and
add the description field from the sub-table.
 
Top