Recent content by Petermgr

Thanks Bob, That wasn't a good response on my part, sorry. I should rephrase: The majority of records are keyed with 7 characters. I will try the Right() function for the last seven characters. I'm not familiar with Len() function since I've never had to use it in the past. But I'll try it...

Hi Mark, There are times where someone, by error, keys in "T4T 1L". So I should clarify, it's not always 7 characters. But the majority of records are keyed with 7 characters. Thanks, Peter

Hi Bob, Thanks for the reply. For the most part, yes, always 7 characters. Peter

Hi, I have one field called FULL_ADDRESS. From that field I am going to populate two other fields. One called ADD_1 and the other, ADD_2. In the FULL_ADDRESS field I have the following text : "BOX 2747 ROCKY MOUNTAIN HOUSE AB T4T 1L7" I want ADD_1 updated to: "BOX 2747 ROCKY MOUNTAIN HOUSE...