I have a table with fields that record a components stock code and it's serial number.
I would like to be able to query this table to find any record in any of the serial number fields that match the number I scan in with a scanner. At the moment I can only search on the "master" serial number and list all the serial numbers associated to it.

I have tried the search function on the page and have not come up with any results, help does not provide any meaningful solution.

The simplest way, I think, would be to create a parameter query. Create a query with all your serial number fields and then in the criteria line below each field type in something like this:

Like [Enter serial number:]

You will need to enter this into each serial number field, but you should do it on a separate line for each (so there is an "or" in between the criteria). This way you should be able to enter a single serial number and have it search across several fields.

HTH

You could utilize the the OR part of the query criteria. Depends on how many fields you have to search for whether or not this is a good method, but it works.