Change Column names in a select Query

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I All

Hope someone can help me out.

We need to send a report to a company with set column headers i.e. "Company
Name" On our DB this column is named "1st CompanyName"

How can I make the query show "Company Name".

Hope some one can help

Regards

Simon
 
There are a couple of ways to do this, Simon ...

If the record source for your report is a saved query, open the query in
design view. Go to the column in the query where the field [1st
CompanyName] is located. Insert the following to the left of the field
name: "Company Name: " (when you do this, leave off the quotation
marks, but do include the colon and leave a space or two after it.) The
entire thing should now look like:

Company Name: 1st CompanyName

You can also do this from within your report's design view, by clicking on
the Record Source property. When you do this, you will see an ellipsis ...
at the far right edge of the property row. Click this and you will see the
query designer for the record source.


hth,
 
Thanks Cheryl

I have done this before & had forgotten how I had done it.

Regards

Simon


Cheryl Fischer said:
There are a couple of ways to do this, Simon ...

If the record source for your report is a saved query, open the query in
design view. Go to the column in the query where the field [1st
CompanyName] is located. Insert the following to the left of the field
name: "Company Name: " (when you do this, leave off the quotation
marks, but do include the colon and leave a space or two after it.) The
entire thing should now look like:

Company Name: 1st CompanyName

You can also do this from within your report's design view, by clicking on
the Record Source property. When you do this, you will see an ellipsis ....
at the far right edge of the property row. Click this and you will see the
query designer for the record source.


hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Simon said:
I All

Hope someone can help me out.

We need to send a report to a company with set column headers i.e. "Company
Name" On our DB this column is named "1st CompanyName"

How can I make the query show "Company Name".

Hope some one can help

Regards

Simon
Click to expand...
Click to expand...
 
Back
Top