Exporting to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Export a query that contains the field with the actual value you want to go
to Excel.
 
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.
 
Back
Top