SELECT DISTINCT [TBL Employee Details].*FROM [TBL Training Qualifications] INNER JOIN (([TBL Project Types] INNER JOIN ([TBL Power Stations] INNER JOIN (([TBL Sites] INNER JOIN (([TBL Role/Trades] INNER JOIN (([TBL Other Companies] INNER JOIN (([TBL Availability Areas] INNER JOIN ([TBL Employee Details] INNER JOIN [rTBL Employees-Availability] ON [TBL Employee Details].EmpDetID = [rTBL Employees-Availability].[E-A FKEmployeeID]) ON [TBL Availability Areas].AvaAreID = [rTBL Employees-Availability].[E-A FKAvailabilityID]) INNER JOIN [rTBL Employees-Other Companies] ON [TBL Employee Details].EmpDetID = [rTBL Employees-Other Companies].[E-C FKEmployeesID]) ON [TBL Other Companies].OthComID = [rTBL Employees-Other Companies].[E-C FKOtherCompaniesID]) INNER JOIN [rTBL Employees-Roles] ON [TBL Employee Details].EmpDetID = [rTBL Employees-Roles].[E-R FKEmployeeID]) ON [TBL Role/Trades].RolTraID = [rTBL Employees-Roles].[E-R FKRolesID]) INNER JOIN [rTBL Employees-Sites] ON [TBL Employee Details].EmpDetID = [rTBL Employees-Sites].[E-S FKEmployeeID]) ON [TBL Sites].SiteID = [rTBL Employees-Sites].[E-S FKSiteID]) INNER JOIN [rTBL Employees-Stations-Projects] ON [TBL Employee Details].EmpDetID = [rTBL Employees-Stations-Projects].[E-P-S FKEmployeeID]) ON [TBL Power Stations].PowStaID = [rTBL Employees-Stations-Projects].[E-P-S FKPStationID]) ON [TBL Project Types].ProTypID = [rTBL Employees-Stations-Projects].[E-P-S FKProjectID]) INNER JOIN [rTBL Employees-Training] ON [TBL Employee Details].EmpDetID = [rTBL Employees-Training].[E-T FKEmployeeID]) ON [TBL Training Qualifications].TraQuaID = [rTBL Employees-Training].[E-T FKTrainingID]
WHERE ((([TBL Role/Trades].TraName) Like "*" & [Forms]![iFRM All Search]![Role] & "*") AND (([TBL Training Qualifications].QuaName) Like "*" & [Forms]![iFRM All Search]![Qualification] & "*") AND (([TBL Availability Areas].AreName) Like "*" & [Forms]![iFRM All Search]![Availability] & "*") AND (([TBL Power Stations].StaName) Like "*" & [Forms]![iFRM All Search]![PowerStation] & "*") AND (([TBL Other Companies].ComName) Like "*" & [Forms]![iFRM All Search]![OtherCompanies] & "*") AND (([TBL Sites].SiteName) Like "*" & [Forms]![iFRM All Search]![Site] & "*"));