Change Query Field Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
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!!
Click to expand...

In the query grid, instead of the column LastName, write:
Customer/Entity Name:[LastName]
 
Worked like a gem!!!! thank you both for your help!!

fredg said:
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!!
Click to expand...

In the query grid, instead of the column LastName, write:
Customer/Entity Name:[LastName]
Click to expand...
 
Back
Top