469,331 Members | 5,302 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

HELP! Weird behavior when renaming column in query

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
4 1917
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
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
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
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.

Similar topics

9 posts views Thread by Tom | last post: by
4 posts views Thread by Sarir Khamsi | last post: by
2 posts views Thread by Sudheer Kareem | last post: by
6 posts views Thread by wukexin | last post: by
6 posts views Thread by d.warnermurray | last post: by
5 posts views Thread by Craig Keightley | last post: by
5 posts views Thread by Steve Teeples | last post: by
9 posts views Thread by JJ | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Purva khokhar | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.