Question: Is there a way to make the unmatched query return the records that have multiple items but the same information?
I am running an unmatched query against a table and an SQL query. Everything works for the records that do not exist in the query. My issue lies in that records that should be repeated are not recognized when more than one record exists in the query.
These are aircraft parts that are required to be installed and tracked. Each part has code associated with its location LOC
. In some cases the parts have the same LOC
code but multiple parts are installed.
Example: In one case we have 8 bolts that are installed. The table lists each bolt individually and they all have the same LOC
. If only one bolt is installed, the unmatched query does not return a value for the 7 remaining bolts that are not installed. It sees the one bolt and moves on.
Is there a way to make the unmatched query return the records that have multiple items but the same LOC
and Name
?
SELECT [MCDS-E].MODEL, [MCDS-E].LOC, [MCDS-E].NOMENCLATURE, [MCDS-E].CHANGE_TYPE,
[MCDS-E].TBO, [MCDS-E].CHANGE_NUMBER, [MCDS-E].DA2410,
[MCDS-E].LOCAL_TRACKED, [MCDS-E].COMMENTS
FROM [MCDS-E]
LEFT JOIN Select_ACFT ON [MCDS-E].[LOC] = Select_ACFT.[LOC]
WHERE ((([MCDS-E].MODEL)=Forms!Index!Text5)
AND ((Select_ACFT.LOC) Is Null));
My table might have:
LOC NOMENCLATURE
- ABCD123 Bolt
- ABCD123 Bolt
- ABCD123 Bolt
- ABCD123 Bolt
The query might have :
LOC NOMENCLATURE
- ABCD123 Bolt
The match query would not show any results for the other three ABCD123 Bolts that are not installed.
Any assistance would be GREATLY appreciated.
Thanks
Nomenclature
,LOC
or evenModel
? I have an answer but might be confusing how pieces relate. Unmatched query should return allLOC
unless this it the field that indicates installed. – Parfait