Trim a Field?

[soljb]

Hi Guys,
i'm an access newbie. I imported a table into access and one of the fields has some leading spaces. how do i trim them? i've tried doing it with a query and setting the putting

Fieldname: trim([field_name])

into the field box of the query, but it keeps giving me compile errors. please help! thanks!

 

[hermanlaksko]

What you have setup in your query is correct and, just to make absolutely sure, I have testet it here i.e.: Exp: Trim([text_tst])

and it works, as it should, just fine - so your problem lies else where.

 

[LittleSmudge]

So lets look for the "elsewhere"

What type of query do you have this in?

Post the entire query.



Alternativly - the entire UPDATE query as I think you need it is:-

UPDATE TableName SET TableName.FieldName = Trim([FieldName]);

Then just run the query


'ope-that-'elps.

G LS