Select A Character In A Part #

[Dmario]

Our part numbers are 10 or 11 Characters in length. I need to select the 8th
character in the part number which denotes the parts color to do some
analysis. How can I select this 8th character based on what it is. For
instance if the 8th character is an alpha it tells me what color it is, but
if it is numeric it is black, clear, or white. I want to select the colors.

Any help would be greatly appreciated.

 

[John W. Vinson]

Our part numbers are 10 or 11 Characters in length. I need to select the 8th
character in the part number which denotes the parts color to do some
analysis. How can I select this 8th character based on what it is. For
instance if the 8th character is an alpha it tells me what color it is, but
if it is numeric it is black, clear, or white. I want to select the colors.

Any help would be greatly appreciated.

Put a calculated field in a Query:

ColorCode: Mid([partnumber], 8, 1)

You may want to have a small Colors table with values for all the valid color
letters or digits (bear in mind that "3" is a character too, just because it's
a digit doesn't mean you need to interpret it numerically).