Display caption labels in query design

[ThompsonA]

When designing a query in Access 2000, is there a way to display, in the table box, the caption label for each field rather than the actual field name?

My table includes field names that are hardly descriptive while the caption names accurately identify the field contents. When selecting fields for the query, it is cumbersome and time consuming to remember that a field named "TG001" is better described as "Sales Amount."

Thank you for any help you can provide.

 

[rac2]

After you drag a field into the design grid, edit the cell like this -

"Sales Amount": TG001

This is the same as

SELECT TG001 AS "Sales Amount"

in SQL View.