Show alpha characters(variable) prior to 1st space.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working in Access97 and need a query's field result to show only the
alpha characters (which are variable-with 2-4 characters) prior to 1st space.
(Ex: BAN 34=BAN; WWCC 3456=WWCC).
 
You're welcome

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Arbo M said:
Perfect! Thank you!
Arbo M

Lynn Trapp said:
Left([YourField],Instr([YourField]," ") - 1)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


ArboM said:
I'm working in Access97 and need a query's field result to show only the
alpha characters (which are variable-with 2-4 characters) prior to 1st space.
(Ex: BAN 34=BAN; WWCC 3456=WWCC).
Click to expand...
Click to expand...
Click to expand...
 
Back
Top