Data prefixed by space

[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.

 

[mtress]

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

 

[mtress]

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.

.

.

 

[Duane Hookom]

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

--
Duane Hookom
MS Access MVP
--

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.

.

.