Remove Blank Spaces in a query

[Kosmo2]

Hi,I have a database which is based on an EXCEL file import, however I have some fields which have multiple spaces before the data , I would like to remove the spaces in the query and align the data to the left but leave the spaces intact in the table , any Ideas ???

Example (Align all data to the left) :

2FF-38125MA2
40351-10
4E4365-xx
AN970-x
AS3209-015
B020403
B020403

 

[Golom]

UPDATE tbl SET Field = Trim$(Field)

 

[Kosmo2]

This wont modify the data im my table will it ?? I need that to stay intact

 

[dhookom]

I don't think Kosmo2 wants to update the data in the table. A query can use the same expression as Golom suggested:
TrimField: Trim([Field])

Duane
MS Access MVP

 

[Kosmo2]

Your Correct Duane aand it works perfectly , Thanks ,
thanks also to Golom, this is usefull for another task I have



Mick