By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,128 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Change the field name

P: n/a
Ray
I tried to change the field name in a query using "New Name: [Field
Name]". It did not work at all and just display the caption of the
Field Name. Is it possible to change the field name or use a new
caption in query?

Thanks,

Ray
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 30 Jul 2004 09:12:43 -0700, ra*******@yahoo.com.hk (Ray) wrote:
I tried to change the field name in a query using "New Name: [Field
Name]". It did not work at all and just display the caption of the
Field Name. Is it possible to change the field name or use a new
caption in query?


Use "as" in the query. Something like:

select field1 as newname from mytable

mike
Nov 13 '05 #2

P: n/a
It should work. Is this by chance what you see when you open a form that is
set to datasheet view that is based on the query in question. If so and you
added this name heading to the query after you designed the form the result
will not show. If you form has an attached label to the control type the
name you want to appear as the column heading into the label. If there
isn't a label type the name you want to appear as the column heading in the
Name of the control or after changing your query, open your form, delete the
controls and re-add them. Hope this helps.

--
Reggie

----------
"Mike Preston" <mb**************@pacbell.net> wrote in message
news:41****************@news.INDIVIDUAL.NET...
On 30 Jul 2004 09:12:43 -0700, ra*******@yahoo.com.hk (Ray) wrote:
I tried to change the field name in a query using "New Name: [Field
Name]". It did not work at all and just display the caption of the
Field Name. Is it possible to change the field name or use a new
caption in query?


Use "as" in the query. Something like:

select field1 as newname from mytable

mike

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.