Make query headings just contain field names?

[SaraD]

I've created Query2 based on Query1. When I select individual fields from
Query1, the datasheet view displays the original query name in the column
heading along with the field name:
Query1.FirstName

Is there a way to just display the field name:
FirstName

I'm using Access 2007.

 

[Stefan Hoffmann]

hi Sara,

Is there a way to just display the field name:
FirstName

Open your query in the designer and change the field selection to

FirstName: Query1.FirstName


mfG
--> stefan <--