Removing spaces from a lot of records at once

[Josh]

I would like to take my DB and somehow run an update
query (or something) to remove spaces from a field. There
are 3500 records and 2 fields that need this done and I
don't want to do them one at a time. Any suggestions??

Thanks in advance,

Josh

 

[PC Datasheet]

You can remove leading spaces, trailing spaces or both with the LTrim, RTrim or
Trim functions in an update query.