J
joe_G
Hello,
I have a database of over 10,000 part numbers that are six characters
long and should be in this format: XXXXXX; however, I noticed many
records in the table as XX XXXX. The part numbers are any letter or
number combination and I'm just using the Xs as an example. Basically,
what query can I run in access to find all instances of records in the
format of XX XXXX
I have a database of over 10,000 part numbers that are six characters
long and should be in this format: XXXXXX; however, I noticed many
records in the table as XX XXXX. The part numbers are any letter or
number combination and I'm just using the Xs as an example. Basically,
what query can I run in access to find all instances of records in the
format of XX XXXX