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 record rows where the same serial numbers are present.
Any help please?
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 record rows where the same serial numbers are present.
Any help please?