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
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
Comment