Make query headings just contain field names?

  • Thread starter Thread starter SaraD
  • Start date Start date
S

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.
 
hi Sara,

Is there a way to just display the field name:
FirstName
Click to expand...
Open your query in the designer and change the field selection to

FirstName: Query1.FirstName


mfG
--> stefan <--
 
Back
Top