Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

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

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.