Eliminating leading spaces in a field using an Update Query 1

[texan1956]

I need to know how to use an Update Query to eliminate leading spaces in a table. As a fairly new Access user, this is something I have not done. Thanks in advance for any help!

 

[hellferret]

Create an update query including all fields you want to remove the leading spaces from.

In the UpdateTo boxes put LTRIM(<fieldname>) for each field.

Instead of LTRIM(), RTRIM() removes trailing spaces and TRIM() will remove both.