Paul has attended:
Access Intermediate course
Access
How do you trim data in a query or a table for a whole column?
RE: Access
Hi Paul
Thank you for the question.
Did you mean Trim as remove the spaces from either end of the value? If so you can use a function called Trim() in your query.
If you meant trim as trim to a set length you could use the function Left() in your query.
You can find text functions in the expression builder in FUnctions - Built-In FUnctions then scroll to the bottom of the middle list to select Text.
I hope that helps
Laura GB