Need to do a comparison query based on a field with 13 or 12 chara

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
So you need to calculate the value
Mid(SomeField,2,11)
returns characters 2 to 12 in the field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Need to delete the last 13 characters of a field 3
Query field size quandry 2
Query / Count Length Of Field 3
How do I Excel formula =LEFT(A2,LEN(A2)-3) in an Access Query 3
Table has a variable size filed. limit filed size to left 10 chara 1
Need to see everything in field except the last two characters 4
Truncating a field in a table, need suggestions 5

Back
Top