How to trim entries in a column or table

[Gerry Wolff]

I understand that, if I want to trim leading and trailing blanks in a
string, I should use the 'trim' function.

But it is not at all clear to me how I should use this function to
trim all the entries in a column or in a table.

Please could someone explain what I need to do.

Many thanks.

 

[elbyc]

Use a query on the table. So if you have the field [Trimthis] in the
table [mytable] you would add the table [mytable] to a new query in
design mode. Then in the first line of the field, type NewName:trim
([Trimthis])

 

[Gerry Wolff]

Use a query on the table. So if you have the field [Trimthis] in the
table [mytable] you would add the table [mytable] to a new query in
design mode. Then in the first line of the field, type NewName:trim
([Trimthis])

OK, many thanks.