TRIM function in query

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

What function in query design do I use to trim all the characters including
spaces except the 1st three characters (number)? I am thinking of TRIM
function, but then not sure what the formula is. Thanks

Example:
222 SPACER = result 222
555nut bolt = 555
 
Just FYI (For Your Information), TRIM removes leading and trailing space
characters from a text string.

TRIM (" AAA B C ") will return "AAA B C"

Note the internal spaces are retained, just those at the beginning and
end have been removed.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Try left$([field_name],3)




Hello,

What function in query design do I use to trim all the characters including
spaces except the 1st three characters (number)? I am thinking of TRIM
function, but then not sure what the formula is. Thanks

Example:
222 SPACER = result 222
555nut bolt = 555
Click to expand...
Click to expand...
 
Back
Top