Query Multiple Fields for the same value to return a list of records (primary keys)
I have a database (Access 2013) where I store modifications done to engineering parts. I have 10 fields each with the same lookup so that users can select multiple parts the modification has been applied to.
ModID: MODIFICATION-001 (Primary Key)
PartAppliedTo2: Example 2
PartAppliedTo4: Example 4
PartAppliedTo5: Example 5
I need to be able to query all of these fields (PartAppliedTo1-10) with a part name and return a list of modifications that have been done to this part.
It works if I only apply the criteria to one of these 'PartAppliedTo' fields but multiple fields just returns no value.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!