Change Query Field Name

[Guest]

Hello,

I have a query with the field name "LastName". When I pull a report and
export it to excel at the top of the column it come out as "LastName". How
can I change it in the query so when I export to excel the column heading
says "Customer/Entity Name?

Thanks!!

 

[Ken Snell \(MVP\)]

Use an alias:

SELECT LastName AS [Customer/Entity Name]
FROM TableName;

 

[fredg]

Hello,

I have a query with the field name "LastName". When I pull a report and
export it to excel at the top of the column it come out as "LastName". How
can I change it in the query so when I export to excel the column heading
says "Customer/Entity Name?

Thanks!!

In the query grid, instead of the column LastName, write:
Customer/Entity Name:[LastName]

 

[Guest]

Worked like a gem!!!! thank you both for your help!!

Hello,

I have a query with the field name "LastName". When I pull a report and
export it to excel at the top of the column it come out as "LastName". How
can I change it in the query so when I export to excel the column heading
says "Customer/Entity Name?

Thanks!!

In the query grid, instead of the column LastName, write:
Customer/Entity Name:[LastName]