Data prefixed by space

  • Thread starter Thread starter mtress
  • Start date Start date
M

mtress

My query is:
SELECT [Items].[Item]
FROM Items;

All the data in the Item field is prefixed by a space.
How can I get rid of the space? Note that my SQL
knowledge is very limited. If there's an addition to
above query, where in the query do I make the change?
Thanks.
 
Never mind. Finally understood the answer I had received
from "Jeff Boyce" earlier.
SELECT Items.Item, Trim([Item]) AS New
FROM Items;
 
This worked, but when I went back to look at it, now I'm
getting:
Compile error. in query expression 'Trim([Item])'.

Can anyone help?
-----Original Message-----
Never mind. Finally understood the answer I had received
from "Jeff Boyce" earlier.
SELECT Items.Item, Trim([Item]) AS New
FROM Items;

-----Original Message-----
My query is:
SELECT [Items].[Item]
FROM Items;

All the data in the Item field is prefixed by a space.
How can I get rid of the space? Note that my SQL
knowledge is very limited. If there's an addition to
above query, where in the query do I make the change?
Thanks.

.
Click to expand...
.
Click to expand...
 
You might have a broken reference. Check this page
http://www.mvps.org/access/bugs/bugs0001.htm.

--
Duane Hookom
MS Access MVP
--

mtress said:
This worked, but when I went back to look at it, now I'm
getting:
Compile error. in query expression 'Trim([Item])'.

Can anyone help?
-----Original Message-----
Never mind. Finally understood the answer I had received
from "Jeff Boyce" earlier.
SELECT Items.Item, Trim([Item]) AS New
FROM Items;

-----Original Message-----
My query is:
SELECT [Items].[Item]
FROM Items;

All the data in the Item field is prefixed by a space.
How can I get rid of the space? Note that my SQL
knowledge is very limited. If there's an addition to
above query, where in the query do I make the change?
Thanks.

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