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