UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Can It Be Done?, Access 2003    
 
   
Bill T
post Dec 7 2017, 11:59 AM
Post#1



Posts: 75
Joined: 12-June 10



I am trying to populate one field with a word based on the the first character in another field using a lookup table. I can get the first character by using =Left([CompanyName], 1).
i.e. if the character trimmed is an "F" then I need to populate the other field with the value "Family". The lookup table has 8 rows so would I need to use the Case function?
The trimmed letter is not always the first letter of the name to be stored by the way.

Thanks
Bill

--------------------
Bill Tweedy
Go to the top of the page
 

Posts in this topic



Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 05:44 PM