Queries to Extract Multiple Criteria

[soldat452002]

Hello, I need help desperately

I have 2 tables (tblUser) and a Linked Excel spreadsheet (CMPReport) .
"I attached a relationships screenshot"

TblUser has all users register to our site.

CMPReport has all Training (4-5 Certificates) those users need to complete and has to be uploaded from a website on a daily basis. *reason why I use a link spreadsheet*

LP Status 1,2,3,4,5,6,7 returns a "failed, passed or in Progress" text field
Certification AZ,CA,OR,WA, returns a Date Field.

I Build a query in Access that extracts all data from tblUsers and adds Training Status from CMPReport (Certificates), united by Field called EID (A number Field)

I'm using the following expression.
Training Status: IIf([LP Status]="Passed",iif[LP1 Status]="Passed",etc, "Complete")

I want my Query to extract only those users that "Passed" any of those certificates and the dates (Would this expression be sufficient?)

Unfortunely since Link Data "CMPReport" is in Excel and the TblUser is in Access, I cannot tell the "TblUser" that a user completed Training because you cannot update a build query using a Link Excel table. So How do I manage this?:banghead:

Any Assistance is appreciated.