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

HELP! Weird behavior when renaming column in query

P: n/a
I have a column in a table named "Hospice". I have a make table query
that pulls in this column but renames the column in the result to
"Hospice (Yes/No)". The column name in the resulting table is
"Hospice(Yes/No)", and the query design (after being saved) also shows
"Hospice(Yes/No)" as the alias for the new column. Both the query and
the resulting table remove the <spacebetween the "e" in Hospice and
the open "(". Any ideas? TIA.

Nov 5 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Some additional info:

I have another column named "WorkingAged" that I rename to "Working
Aged (Yes/No)". That works just fine. So I tried adding an additional
space to the "Hospice" column by renaming it to "Hos pice (Yes/No)"
and that also works. So Access seems to object to only having ONE
space in the new name. Since I can't use the name "Hos<space>pice (Yes/
No), I do need to figure out how to make Access respect the correct
name.

Captain Jack Sparrow wrote:
I have a column in a table named "Hospice". I have a make table query
that pulls in this column but renames the column in the result to
"Hospice (Yes/No)". The column name in the resulting table is
"Hospice(Yes/No)", and the query design (after being saved) also shows
"Hospice(Yes/No)" as the alias for the new column. Both the query and
the resulting table remove the <spacebetween the "e" in Hospice and
the open "(". Any ideas? TIA.
Nov 5 '07 #2

P: n/a
Captain Jack Sparrow wrote:
Some additional info:

I have another column named "WorkingAged" that I rename to "Working
Aged (Yes/No)". That works just fine. So I tried adding an additional
space to the "Hospice" column by renaming it to "Hos pice (Yes/No)"
and that also works. So Access seems to object to only having ONE
space in the new name. Since I can't use the name "Hos<space>pice (Yes/
No), I do need to figure out how to make Access respect the correct
name.

Captain Jack Sparrow wrote:
>>I have a column in a table named "Hospice". I have a make table query
that pulls in this column but renames the column in the result to
"Hospice (Yes/No)". The column name in the resulting table is
"Hospice(Yes/No)", and the query design (after being saved) also shows
"Hospice(Yes/No)" as the alias for the new column. Both the query and
the resulting table remove the <spacebetween the "e" in Hospice and
the open "(". Any ideas? TIA.

Just curious. If you open the table in design mode does it have a
Caption field set to some value?
Nov 5 '07 #3

P: n/a
Nope.

Salad wrote:
Just curious. If you open the table in design mode does it have a
Caption field set to some value?
Nov 5 '07 #4

P: n/a
Captain Jack Sparrow wrote:
Nope.

Salad wrote:
>>Just curious. If you open the table in design mode does it have a
Caption field set to some value?

I created Table4 with 1 field; Hospice type Yes/No

I then created a SQL statement to create Table5
SELECT Table4.Hospice AS [Hospice (Yes/No)] INTO Table5
FROM Table4;

Table5 is created and the field name is "Hospice (Yes/No)"

I then added a couple of fields to Table4 and reran a new SQL to create
Table5
SELECT Table4.ID, Table4.Something, Table4.Hospice AS [Hospice (Yes/No)]
INTO Table5 FROM Table4;

And it works fine. I did this with A97. I can test on A2003 if you'd
like. But you could test if you create a Table4 and have 3 fields; ID,
Something, and Hospice and then run the query.


Nov 6 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.