Trim function in query

[VegaLA]

Hi all,
I have a local table that has data imported from a spreadsheet
and we have discovered that one of the fields brings in trailing spaces. Since the Access DB has some querys to manaipulate the data I thought I would just create a qry that would trim the value of that field but I am getting error messages when I try to run the query.
Basically it is a update query with the field value written as:-

Code: Trim(

)

I am leaving the update field in the qry blank and it complains about it not having  a destination field which is understandable so how do I go about trimming the value of a field in a query. Is it even possible ? 

Thanks in advance,
Mitch....

 

[KenHigg]

The 'Trim(

)' should go in the 'update to' line and the 'code' fld name should be on the 'field' line.

And 'code' is a bad fld name :)

 

[VegaLA]

Thanks Ken,
yes, 'code' is a bad field name but I dare not mess with it myself being the new guy here. I usually play it safe with field names.

Cheers again.

Mitch.........

 

[KenHigg]

Did you get the query to work?

 

[VegaLA]

Yup, like a dream !!

Thanks again.