Space in Fieldname of a Query

  • Thread starter Thread starter Jeefgeorge
  • Start date Start date
J

Jeefgeorge

I have a query that is returning the correct results however, one of the
field names is not as expected.

I type "Qty (Est): Quanity" in the Field row of design view.
If I switch to datasheet view, the field name reads as "Qty (Est)"
However if I close the query and re-open it, the field name reads
"QTY(Est)".....no space.
This poses a problem when the query is transfered to excel, where the Wrap
Text Property is enabled for all cells...this field name then reads
QTY(
Est)

the space is needed since I would like it to read
QTY
(Est)

Any help is appreciated....I'm very frustrated with this one
 
Try this (but I haven't tested it). Open your query and fix the space. Then
click on the SQL view. You should see the syntax for the query. Put square
brackets around your alias.

SELECT Quanity As [Qty (Est)]
FROM MyTable

Then save the query immediately.
 
The brackets were already there in SQL view. I have a work around....if I
use 2 spaces between Qty and (Est) it keeps them both. I still don't
understand why a single space is removed.

Bill Mosca said:
Try this (but I haven't tested it). Open your query and fix the space. Then
click on the SQL view. You should see the syntax for the query. Put square
brackets around your alias.

SELECT Quanity As [Qty (Est)]
FROM MyTable

Then save the query immediately.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/MS_Access_Professionals




Jeefgeorge said:
I have a query that is returning the correct results however, one of the
field names is not as expected.

I type "Qty (Est): Quanity" in the Field row of design view.
If I switch to datasheet view, the field name reads as "Qty (Est)"
However if I close the query and re-open it, the field name reads
"QTY(Est)".....no space.
This poses a problem when the query is transfered to excel, where the Wrap
Text Property is enabled for all cells...this field name then reads
QTY(
Est)

the space is needed since I would like it to read
QTY
(Est)

Any help is appreciated....I'm very frustrated with this one
Click to expand...
Click to expand...
 
I don't know why either. Do you have AutoCorrect turned on?

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/MS_Access_Professionals




Jeefgeorge said:
The brackets were already there in SQL view. I have a work around....if I
use 2 spaces between Qty and (Est) it keeps them both. I still don't
understand why a single space is removed.

Bill Mosca said:
Try this (but I haven't tested it). Open your query and fix the space.
Then
click on the SQL view. You should see the syntax for the query. Put
square
brackets around your alias.

SELECT Quanity As [Qty (Est)]
FROM MyTable

Then save the query immediately.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/MS_Access_Professionals




Jeefgeorge said:
I have a query that is returning the correct results however, one of the
field names is not as expected.

I type "Qty (Est): Quanity" in the Field row of design view.
If I switch to datasheet view, the field name reads as "Qty (Est)"
However if I close the query and re-open it, the field name reads
"QTY(Est)".....no space.
This poses a problem when the query is transfered to excel, where the
Wrap
Text Property is enabled for all cells...this field name then reads
QTY(
Est)

the space is needed since I would like it to read
QTY
(Est)

Any help is appreciated....I'm very frustrated with this one
Click to expand...
Click to expand...
Click to expand...
 
Back
Top