LTrim$ Function

[Stumped]

I have a text column that has leading and training blank spaces (not nulls). I am trying to use an update query with the LTrim$ function to remove the leading spaces. The syntax should be LTRIM$([column name]), but this is not working as it is trying to insert the string literal column name into the value of the column for all 207 rows. What am I doing wrong?

 

[Van T. Dinh]

Try using:

Trim([FieldName])

--
HTH
Van T. Dinh
MVP (Access)

I have a text column that has leading and training blank spaces (not

nulls). I am trying to use an update query with the LTrim$ function to
remove the leading spaces. The syntax should be LTRIM$([column name]), but
this is not working as it is trying to insert the string literal column name
into the value of the column for all 207 rows. What am I doing wrong?

 

[John Spencer (MVP)]

OK, can you copy and post the SQL of your query?

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

This might give us a hint.