First Letter of first two words in a field

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • IreneADS
    New Member
    • Jul 2015
    • 1

    First Letter of first two words in a field

    Hello

    I have a field called [Hotel] and in the field there can be 2 or three words (Best Western Inn, or Holiday Inn & Suites Etc.) and I need the first letter of the first two words in different field... BW or HI etc.
    I can easily get the first letter but the second is proving to be very difficult.

    Using Access 2007
    Last edited by IreneADS; Jul 23 '15, 09:33 PM. Reason: forgot to write program using.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Use the InStr() function to find the location of the first space, then use the Mid() function to extract the first character after that location.

    Comment

    Working...