Preventing a Query from Overwriting Field Names in a Table

[Wiretwister]

Windows 10, Access 2000



Hello,

Working on modifying a query to find possible component substitutes to include in a Bill of Material. The query shown here writes data to a table (Bill of Material Table). I would like the table to have these 6 (more user-friendly) field names: BOM Part Number, Item Number, Component Part Number, Quantity, BOM Notes, and Effective Date. When I run the query, it changes the field names to: PARPRT_02, UDFKEY_02, COMPRT_02, QTYPER_02, Notes_61, and EFFDTE_02.

What can I do to keep my chosen field names in place?

Thanks in advance!

[Welshgasman]

Use an alias for each.
Though you could just have captions for those fields.

[Micron]

Users shouldn't be seeing tables or query results as datasheets, so this should be a non-starter unless this is something you as the developer needs to have.