Search results

I have a database with 5 fields, each field contains serial number records. The same serial number can appear in one or more fields (can be duplicated) I need to make a query that if I enter a single serial number (ideally from a form), the query searches the whole database and reports the only...

I have a one field table that has PCB names recorded. I have another table with several fields one of which is a lookup field to select one of the PCB names from the first table. This populates the PCB name OK. I have a query built on the 2nd table that reports 4 fields including the PCB names...