How to trim entries in a column or table

  • Thread starter Thread starter Gerry Wolff
  • Start date Start date
G

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.
 
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])
 
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])
Click to expand...

OK, many thanks.
 
Back
Top