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

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.

Go to the top of the page

Posts in this topic

Custom Search

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