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: 79
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
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    9th December 2018 - 05:01 PM