Part Number Lookup

[jacobbiljo]

Hopefully this hasnt been answered too many times already but I am setting up a simple Part Number database and would like to be able to search by sections of our part number. Our parts numbers are divided up in a form something like this:x-xx-xxx with each section signifying a different group but all being stored as one masked text variable. What is the simplest way to be able to query parts of this number so for example i look for only parts from the electrical connectors group 1-15-_ _ _

Thanks for any help or redirection to previous topics
Jacob



On a side note i would have though this was a common task is there not any examples out there of this type of system?

[CGM3]

Create a query on the Part Number table, and along with the fields you want to display put this in an empty field of the query--

=Left([PartNumber], 4)

--which, after you press Enter, will be changed to--

Expr1: Left([PartNumber], 4)

Then, in the Criteria field of that column, enter--

=[Group]

When you execute the query, it will prompt you for a value for [Group] -- in your example, enter 1-15 -- then return all records where the first four characters equal whatever was entered (here, 1-15).