D
DBGuy11
I need to do a comparison query based on a field that sometimes contains 12
characters and sometimes contains 13 characters. I need to ignore the first
character of the field, which i can do by itself, but if there are 13
characters in the field then I have to also ignore the last character the
13th character in the field. I could do this in excel manually using text to
columns, but I have to do several comparisons and I'm sure there's a way to
do it automatically in access.
Thanks in advance
characters and sometimes contains 13 characters. I need to ignore the first
character of the field, which i can do by itself, but if there are 13
characters in the field then I have to also ignore the last character the
13th character in the field. I could do this in excel manually using text to
columns, but I have to do several comparisons and I'm sure there's a way to
do it automatically in access.
Thanks in advance