*_____Duplicate_Sample_Date-Times

SELECT [*_Unique LDD_Samples].DateCollected AS Expr1, Count([*_Unique LDD_Samples].ClientSampleId) AS CountOfClientSampleId, First([*_Unique LDD_Samples].ClientSampleId) AS [First Sample Name], Last([*_Unique LDD_Samples].ClientSampleId) AS [Last Sample Name]
FROM [*_Unique LDD_Samples]
GROUP BY [*_Unique LDD_Samples].DateCollected
ORDER BY First([*_Unique LDD_Samples].ClientSampleId);


*_____Export_Total_Record_Count

SELECT Count([*_FDD_Exported_Records].WACS_Testsite_Name) AS CountOfWACS_Testsite_Name
FROM [*_FDD_Exported_Records];
     UNION SELECT Count([*_LDD_Exported_Records].ClientSampleId) AS CountOfClientSampleId
FROM [*_LDD_Exported_Records];


*____Export_FDD_Record_Count

SELECT Count([*_FDD_Exported_Records].WACS_Testsite_Name) AS ["fdd RECORDS eXPORTED"]
FROM [*_FDD_Exported_Records];


*____Export_LDD_Record_Count

SELECT Count([*_LDD_Exported_Records].ClientSampleId) AS CountOfClientSampleId
FROM [*_LDD_Exported_Records]
HAVING (((Count([*_LDD_Exported_Records].ClientSampleId)) Not Like "*blank*"));


*____PRP_(non-WACS)_Field_EDD

SELECT DISTINCT [*_FDD_Elements_From_LDD].WACS_Testsite_ID, [*_FDD_Elements_From_LDD].WACS_Testsite_Name, [*_FDD_Elements_From_LDD].WACS_Facility_ID, [*_FDD_Elements_From_LDD].WACS_Facility_Name, IIf([*_FDD_Elements_From_LDD]![Matrix] Like "*S*","E",IIf([WACS_Report_Type] Like "*LP*","E",IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","E",""))) AS Sample_Type, [*_FDD_Elements_From_LDD].Matrix, IIf([WACS_Report_Type] Like "*LP*","",IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Measurement_Method])) AS Field_Measurement_Method, IIf([WACS_Report_Type] Like "*LP*","",IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_NameAnalyteName])) AS Field_Parameter_Name, [*_FDD_Elements_From_LDD].Result, IIf([WACS_Report_Type] Like "*LP*","",IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Result_Units])) AS Result_Units, IIf([WACS_Report_Type] Like "*LP*","",IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_Qualifier_Code])) AS Field_Parameter_Qualifier_Code, [*_FDD_Elements_From_LDD].Field_Comments, [*_FDD_Elements_From_LDD].Sampling_Personnel, [*_FDD_Elements_From_LDD].Collection_Agency, [*_FDD_Elements_From_LDD].Date_Sampled, [*_FDD_Elements_From_LDD].Shipping_Batch_ID, [*_FDD_Elements_From_LDD].Well_Purged_Flag, [*_FDD_Elements_From_LDD].WACS_Report_Type
FROM [*_FDD_Elements_From_LDD] INNER JOIN [*_Field_Measured_Parameters] ON [*_FDD_Elements_From_LDD].Matrix = [*_Field_Measured_Parameters].Matrix
ORDER BY [*_FDD_Elements_From_LDD].WACS_Testsite_Name, IIf([WACS_Report_Type] Like "*LP*","",IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_NameAnalyteName]));


*____WACS_(non-PRP)_Field_EDD

SELECT DISTINCT tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_ID, [*_FDD_Elements_From_LDD].WACS_Testsite_Name, [*_FDD_Elements_From_LDD].WACS_Facility_ID, [*_FDD_Elements_From_LDD].WACS_Facility_Name, [*_FDD_Elements_From_LDD].Sample_Type, [*_FDD_Elements_From_LDD].Matrix, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Measurement_Method]) AS Field_Measurement_Method, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_NameAnalyteName]) AS Field_Parameter_Name, [*_FDD_Elements_From_LDD].Result, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Result_Units]) AS Result_Units, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_Qualifier_Code]) AS Field_Parameter_Qualifier_Code, [*_FDD_Elements_From_LDD].Field_Comments, [*_FDD_Elements_From_LDD].Sampling_Personnel, [*_FDD_Elements_From_LDD].Collection_Agency, [*_FDD_Elements_From_LDD].Date_Sampled, [*_FDD_Elements_From_LDD].Shipping_Batch_ID, [*_FDD_Elements_From_LDD].Well_Purged_Flag, [*_FDD_Elements_From_LDD].WACS_Report_Type
FROM tblWacs_Svl_SolidWaste_Testsite_Inventory INNER JOIN ([*_FDD_Elements_From_LDD] INNER JOIN [*_Field_Measured_Parameters] ON [*_FDD_Elements_From_LDD].Matrix = [*_Field_Measured_Parameters].Matrix) ON (tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_Name = [*_FDD_Elements_From_LDD].WACS_Testsite_Name) AND (tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_ID = [*_FDD_Elements_From_LDD].WACS_Facility_ID)
ORDER BY [*_FDD_Elements_From_LDD].WACS_Testsite_Name, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_NameAnalyteName])
UNION SELECT DISTINCT "" AS WACS_Testsite_ID, tblHoldDepEdd.ClientSampleId AS WACS_Testsite_Name, tblHoldDepEdd.ProjectNumber AS WACS_Facility_ID, tblHoldDepEdd.ProjectName AS WACS_Facility_Name, "E" AS Sample_Type, IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","W","S") AS Matrix, "" AS Field_Measurement_Method, "" AS Field_Parameter_NameAnalyteName, "" AS Result, "" AS Result_Units, "" AS Field_Parameter_Qualifier_Code, "" AS Field_Comments, "" AS Sampling_Personnel, "" AS Collection_Agency, tblHoldDepEdd.DateCollected AS Date_Sampled, tblHoldDepEdd.ShippingBatchID AS Shipping_Batch_ID, IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","Y","") AS Well_Purged_Flag, IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","SEMGW","ASMNT") AS WACS_Report_Type
FROM tblHoldDepEdd
WHERE (((tblHoldDepEdd.ClientSampleId) Like "*blank*" Or (tblHoldDepEdd.ClientSampleId) Like "*dup*" Or (tblHoldDepEdd.ClientSampleId) Like "*resample*" Or (tblHoldDepEdd.ClientSampleId) Like "*conf*") AND ((tblHoldDepEdd.AnalyteType)="TRG") AND ((tblHoldDepEdd.QCType)="N"));


*___Check Lab(s) reporting data in the lab EDD

SELECT DISTINCT tblHoldDepEdd.LabID AS DOHE, tblSvlLabId.Description AS [Lab Name], [Contact] AS [Contact(s)], [Phone] AS [Phone #], [Email] AS [Email(s)], [Notes] AS [Note]
FROM (tblHoldDepEdd LEFT JOIN tblSvlLabId ON tblHoldDepEdd.LabID = tblSvlLabId.LabID) LEFT JOIN [*_Lab_Information] ON tblHoldDepEdd.LabID = [*_Lab_Information].[Lab ID/ DOHE ];


*___Check_where_MDL=PQL_&_Result=PQL

SELECT tblHoldDepEdd.RecordId, tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.LabAnalysisRefMethodID, tblHoldDepEdd.ClientAnalyteID, tblHoldDepEdd.AnalyteName, tblHoldDepEdd.Result, tblHoldDepEdd.ResultUnits, tblHoldDepEdd.LabQualifiers, tblHoldDepEdd.DetectionLimit, tblHoldDepEdd.AnalyteType, tblHoldDepEdd.Dilution, tblHoldDepEdd.ReportingLimit, tblHoldDepEdd.ProjectNumber, tblHoldDepEdd.ProjectName, tblHoldDepEdd.DateCollected, tblHoldDepEdd.QCType, tblHoldDepEdd.ResultComments
FROM tblHoldDepEdd
WHERE (((tblHoldDepEdd.ClientAnalyteID) Not Like "2030" And (tblHoldDepEdd.ClientAnalyteID) Not Like "1880" And (tblHoldDepEdd.ClientAnalyteID) Not Like "1900" And (tblHoldDepEdd.ClientAnalyteID) Not Like "FL-PHYS-007" And (tblHoldDepEdd.ClientAnalyteID) Not Like "2055" And (tblHoldDepEdd.ClientAnalyteID) Not Like "EPA E1647296" And (tblHoldDepEdd.ClientAnalyteID) Not Like "1610" And (tblHoldDepEdd.ClientAnalyteID) Not Like "*GW*") AND ((tblHoldDepEdd.AnalyteType)="TRG") AND ((tblHoldDepEdd.QCType)="N") AND (([tblHoldDepEdd]![ReportingLimit]/[tblHoldDepEdd]![DetectionLimit]) Like "1") AND (([tblHoldDepEdd]![Result]/[tblHoldDepEdd]![ReportingLimit]) Like "1"));


*___WACS(non-PRP)_Field_EDD

SELECT DISTINCT tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_ID, [*_FDD_Elements_From_LDD].WACS_Testsite_Name, [*_FDD_Elements_From_LDD].WACS_Facility_ID, [*_FDD_Elements_From_LDD].WACS_Facility_Name, [*_FDD_Elements_From_LDD].Sample_Type, [*_FDD_Elements_From_LDD].Matrix, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Measurement_Method]) AS Field_Measurement_Method, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_NameAnalyteName]) AS Field_Parameter_Name, [*_FDD_Elements_From_LDD].Result, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Result_Units]) AS Result_Units, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_Qualifier_Code]) AS Field_Parameter_Qualifier_Code, [*_FDD_Elements_From_LDD].Field_Comments, [*_FDD_Elements_From_LDD].Sampling_Personnel, [*_FDD_Elements_From_LDD].Collection_Agency, [*_FDD_Elements_From_LDD].Date_Sampled, [*_FDD_Elements_From_LDD].Shipping_Batch_ID, [*_FDD_Elements_From_LDD].Well_Purged_Flag, [*_FDD_Elements_From_LDD].WACS_Report_Type
FROM tblWacs_Svl_SolidWaste_Testsite_Inventory INNER JOIN ([*_FDD_Elements_From_LDD] INNER JOIN [*_Field_Measured_Parameters] ON [*_FDD_Elements_From_LDD].Matrix = [*_Field_Measured_Parameters].Matrix) ON (tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_Name = [*_FDD_Elements_From_LDD].WACS_Testsite_Name) AND (tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_ID = [*_FDD_Elements_From_LDD].WACS_Facility_ID)
ORDER BY [*_FDD_Elements_From_LDD].WACS_Testsite_Name, IIf(UCase$([*_FDD_Elements_From_LDD]![WACS_Testsite_Name]) Like "*BLANK*","",[*_Field_Measured_Parameters]![Field_Parameter_NameAnalyteName]);


*__tblSvlProject_BSHW

SELECT DISTINCT tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_ID AS ProjectNumber, tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_Name AS ProjectName, "FALSE" AS Tag
FROM tblWacs_Svl_SolidWaste_Testsite_Inventory;


*__WACS_Compare_Testsite_Names

SELECT [*__WACS_Field EDD].Field_EDD_Testsite_Name AS [Field EDD Testsite Name], [*__WACS_Field EDD].Field_EDD_Testsite_ID, [*__WACS_Testsite_Inv].Inventory_Testsite_Name, [*__WACS_Testsite_Inv_1].Inventory_Testsite_ID AS [Suggested WACS_TestSite_ID], [*__WACS_Field EDD].Field_EDD_Testsite_Name, [*__WACS_Testsite_Inv].Status
FROM ([*__WACS_Field EDD] LEFT JOIN [*__WACS_Testsite_Inv] ON [*__WACS_Field EDD].Field_EDD_Testsite_ID = [*__WACS_Testsite_Inv].Inventory_Testsite_ID) INNER JOIN [*__WACS_Testsite_Inv] AS [*__WACS_Testsite_Inv_1] ON ([*__WACS_Field EDD].Field_EDD_Facility_ID = [*__WACS_Testsite_Inv_1].Inventory_Facility_ID) AND ([*__WACS_Field EDD].Field_EDD_Testsite_Name = [*__WACS_Testsite_Inv_1].Inventory_Testsite_Name)
WHERE (((StrComp([*__WACS_Field EDD]![Field_EDD_Testsite_Name],[*__WACS_Testsite_Inv]![Inventory_Testsite_Name],1)) Not Like "0"));


*__WACS_Field EDD

SELECT DISTINCT tblHoldSolidWasteEdd.WACS_Testsite_Name AS Field_EDD_Testsite_Name, CLng([tblHoldSolidWasteEdd]![WACS_Testsite_ID]) AS Field_EDD_Testsite_ID, [tblHoldSolidWasteEdd]![WACS_Facility_ID] AS Field_EDD_Facility_ID
FROM tblHoldSolidWasteEdd
WHERE (((tblHoldSolidWasteEdd.WACS_Testsite_Name) Not Like "*Blank*"))
ORDER BY tblHoldSolidWasteEdd.WACS_Testsite_Name;


*__WACS_Testsite_Inv

SELECT DISTINCT tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_Name AS Inventory_Testsite_Name, CLng([tblWacs_Svl_SolidWaste_Testsite_Inventory]![WACS_Testsite_ID]) AS Inventory_Testsite_ID, tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_ID AS Inventory_Facility_ID, tblWacs_Svl_SolidWaste_Testsite_Inventory.Status
FROM tblWacs_Svl_SolidWaste_Testsite_Inventory
WHERE (((tblWacs_Svl_SolidWaste_Testsite_Inventory.[Facility Type]) Like "3" Or (tblWacs_Svl_SolidWaste_Testsite_Inventory.[Facility Type]) Like "7"));


*_Check Field Parameters Reported

TRANSFORM Max([tblHoldSolidWasteEdd]![Result] & " " & [tblHoldSolidWasteEdd]![Field_Parameter_Qualifier_Code]) AS Expr1
SELECT tblHoldSolidWasteEdd.WACS_Testsite_ID, tblHoldSolidWasteEdd.WACS_Testsite_Name, tblHoldSolidWasteEdd.Date_Sampled, tblHoldSolidWasteEdd.WACS_Report_Type
FROM tblHoldSolidWasteEdd
GROUP BY tblHoldSolidWasteEdd.WACS_Testsite_ID, tblHoldSolidWasteEdd.WACS_Testsite_Name, tblHoldSolidWasteEdd.Date_Sampled, tblHoldSolidWasteEdd.WACS_Report_Type
ORDER BY tblHoldSolidWasteEdd.WACS_Testsite_Name, tblHoldSolidWasteEdd.Date_Sampled
PIVOT tblHoldSolidWasteEdd.Field_Parameter_Name;


*_Check Lab Analytes Reported

TRANSFORM Min([tblHoldDepEdd]![Result] & " " & [tblHoldDepEdd]![LabQualifiers]) AS Expr1
SELECT tblHoldDepEdd.AnalyteName, tblHoldDepEdd.ResultUnits
FROM tblHoldDepEdd
WHERE (((tblHoldDepEdd.AnalyteType) Like "TRG") AND ((tblHoldDepEdd.QCType) Like "N"))
GROUP BY tblHoldDepEdd.AnalyteName, tblHoldDepEdd.ResultUnits, tblHoldDepEdd.AnalyteType, tblHoldDepEdd.QCType
PIVOT tblHoldDepEdd.ClientSampleId;


*_Duplicate Samples with the same Date/Time Sampled

SELECT DISTINCT tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.DateCollected
FROM tblHoldDepEdd INNER JOIN tblHoldSolidWasteEdd ON tblHoldDepEdd.ClientSampleId = tblHoldSolidWasteEdd.WACS_Testsite_Name
GROUP BY tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.DateCollected, tblHoldSolidWasteEdd.WACS_Testsite_Name, tblHoldDepEdd.QCType, tblHoldDepEdd.AnalyteType
HAVING (((tblHoldDepEdd.QCType) Like "N")) OR (((tblHoldDepEdd.AnalyteType) Like "TRG"))
ORDER BY tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.DateCollected;


*_FDD_Elements_From_LDD

SELECT DISTINCT "" AS WACS_Testsite_ID, tblHoldDepEdd.ClientSampleId AS WACS_Testsite_Name, tblHoldDepEdd.ProjectNumber AS WACS_Facility_ID, tblHoldDepEdd.ProjectName AS WACS_Facility_Name, "E" AS Sample_Type, IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","W",IIf([tblHoldDepEdd]![MatrixID] Like "AIR","A","S")) AS Matrix, "" AS Field_Measurement_Method, "" AS Field_Parameter_NameAnalyteName, "" AS Result, "" AS Result_Units, "" AS Field_Parameter_Qualifier_Code, "" AS Field_Comments, "" AS Sampling_Personnel, "" AS Collection_Agency, tblHoldDepEdd.DateCollected AS Date_Sampled, First(tblHoldDepEdd.ShippingBatchID) AS Shipping_Batch_ID, IIf([tblHoldDepEdd]![MatrixID] Not Like "AQ*","",IIf([tblHoldDepEdd]![LabAnalysisRefMethodID] Like "EPA 131*","","Y")) AS Well_Purged_Flag, IIf([tblHoldDepEdd]![LabAnalysisRefMethodID] Like "*1311*","TCLP",IIf([tblHoldDepEdd]![LabAnalysisRefMethodID] Like "*1312*","SPLP",IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","SEMGW","ASSMT"))) AS WACS_Report_Type
FROM tblHoldDepEdd
GROUP BY tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.ProjectNumber, tblHoldDepEdd.ProjectName, "E", IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","W",IIf([tblHoldDepEdd]![MatrixID] Like "AIR","A","S")), "", tblHoldDepEdd.DateCollected, IIf([tblHoldDepEdd]![MatrixID] Not Like "AQ*","",IIf([tblHoldDepEdd]![LabAnalysisRefMethodID] Like "EPA 131*","","Y")), IIf([tblHoldDepEdd]![LabAnalysisRefMethodID] Like "*1311*","TCLP",IIf([tblHoldDepEdd]![LabAnalysisRefMethodID] Like "*1312*","SPLP",IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","SEMGW","ASSMT"))), "", "", "", "", "", "", "", "", tblHoldDepEdd.AnalyteType, tblHoldDepEdd.QCType
HAVING (((tblHoldDepEdd.AnalyteType)="TRG") AND ((tblHoldDepEdd.QCType)="N"));


*_FDD_Elements_From_LDD for Blanks, Field Duplicates and resampl

SELECT DISTINCT "" AS WACS_Testsite_ID, tblHoldDepEdd.ClientSampleId AS WACS_Testsite_Name, tblHoldDepEdd.ProjectNumber AS WACS_Facility_ID, tblHoldDepEdd.ProjectName AS WACS_Facility_Name, "E" AS Sample_Type, IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","W","S") AS Matrix, "" AS Field_Measurement_Method, "" AS Field_Parameter_NameAnalyteName, "" AS Result, "" AS Result_Units, "" AS Field_Parameter_Qualifier_Code, "" AS Field_Comments, "" AS Sampling_Personnel, "" AS Collection_Agency, tblHoldDepEdd.DateCollected AS Date_Sampled, First(tblHoldDepEdd.ShippingBatchID) AS Shipping_Batch_ID, IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","Y","") AS Well_Purged_Flag, IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","SEMGW","ASSMT") AS WACS_Report_Type
FROM tblHoldDepEdd
GROUP BY "", tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.ProjectNumber, tblHoldDepEdd.ProjectName, "E", IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","W","S"), "", "", "", "", "", "", "", "", tblHoldDepEdd.DateCollected, IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","Y",""), IIf([tblHoldDepEdd]![MatrixID] Like "AQ*","SEMGW","ASSMT"), tblHoldDepEdd.AnalyteType, tblHoldDepEdd.QCType
HAVING (((tblHoldDepEdd.ClientSampleId) Like "*blank*" Or (tblHoldDepEdd.ClientSampleId) Like "*dup*" Or (tblHoldDepEdd.ClientSampleId) Like "*resample*" Or (tblHoldDepEdd.ClientSampleId) Like "*conf*") AND ((tblHoldDepEdd.AnalyteType)="TRG") AND ((tblHoldDepEdd.QCType)="N"));


*_FDD_Exported_Records

SELECT DISTINCT tblHoldSolidWasteEdd.WACS_Testsite_Name, tblHoldSolidWasteEdd.Date_Sampled, tblHoldSolidWasteEdd.Field_Parameter_Name
FROM tblHoldSolidWasteEdd
WHERE (((tblHoldSolidWasteEdd.Result) Is Not Null));


*_Generate Lab EDD without Field Parameters

SELECT tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.LabAnalysisRefMethodID, tblHoldDepEdd.LabSampleId, tblHoldDepEdd.LabID, tblHoldDepEdd.ClientAnalyteID, tblHoldDepEdd.AnalyteName, tblHoldDepEdd.Result, "" AS Error, tblHoldDepEdd.ResultUnits, tblHoldDepEdd.LabQualifiers, tblHoldDepEdd.DetectionLimit, tblHoldDepEdd.AnalyteType, tblHoldDepEdd.Dilution, tblHoldDepEdd.PercentMoisture, tblHoldDepEdd.PercentRecovery, tblHoldDepEdd.RelativePercentDifference, tblHoldDepEdd.ReportingLimit, tblHoldDepEdd.ProjectNumber, tblHoldDepEdd.ProjectName, tblHoldDepEdd.DateCollected, tblHoldDepEdd.MatrixID, tblHoldDepEdd.QCType, tblHoldDepEdd.ShippingBatchID, tblHoldDepEdd.Temperature, tblHoldDepEdd.PreparationType, tblHoldDepEdd.AnalysisType, tblHoldDepEdd.ReportableResult, tblHoldDepEdd.DatePrepared, tblHoldDepEdd.DateAnalyzed, tblHoldDepEdd.TotalOrDissolved, tblHoldDepEdd.PrepBatchID, tblHoldDepEdd.MethodBatchID, tblHoldDepEdd.PreservationIntact, tblHoldDepEdd.QCSpikeAdded, tblHoldDepEdd.ResultComments, tblHoldDepEdd.LabReportingBatchID
FROM tblHoldDepEdd
WHERE (((tblHoldDepEdd.ClientAnalyteID) Not Like "2030" And (tblHoldDepEdd.ClientAnalyteID) Not Like "1880" And (tblHoldDepEdd.ClientAnalyteID) Not Like "1900" And (tblHoldDepEdd.ClientAnalyteID) Not Like "FL-PHYS-007" And (tblHoldDepEdd.ClientAnalyteID) Not Like "2055" And (tblHoldDepEdd.ClientAnalyteID) Not Like "EPA E1647296" And (tblHoldDepEdd.ClientAnalyteID) Not Like "1610" And (tblHoldDepEdd.ClientAnalyteID) Not Like "*GW*"));


*_LDD_Exported_Records

SELECT DISTINCT tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.DateCollected, tblHoldDepEdd.LabAnalysisRefMethodID, tblHoldDepEdd.AnalyteName
FROM tblHoldDepEdd INNER JOIN tblHoldSolidWasteEdd ON (tblHoldSolidWasteEdd.Date_Sampled = tblHoldDepEdd.DateCollected) AND (tblHoldDepEdd.ClientSampleId = tblHoldSolidWasteEdd.WACS_Testsite_Name)
WHERE (((tblHoldDepEdd.ClientSampleId) Not Like "*blank*") AND ((tblHoldDepEdd.AnalyteType) Like "TRG") AND ((tblHoldDepEdd.QCType) Like "N"))
ORDER BY tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.DateCollected;


*_Solid Waste (field) EDD with Field Parameters

SELECT DISTINCT tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_ID, tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_Name, tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_ID, tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_Name, "E" AS Sample_Type, "W" AS Matrix_ID, tblHoldDepEdd.LabAnalysisRefMethodID AS Field_Measurement_Method, tblHoldDepEdd.AnalyteName AS Field_Parameter_NameAnalyteName, tblHoldDepEdd.Result, tblHoldDepEdd.ResultUnits AS Result_Units, "D" AS Field_Parameter_Qualifier_Code, tblHoldDepEdd.ResultComments AS Field_Comments, "" AS Sampling_Personnel, "" AS Collection_Agency, tblHoldDepEdd.DateCollected AS Date_Sampled, tblHoldDepEdd.ShippingBatchID AS Shipping_Batch_ID, "Y" AS Well_Purged_Flag, "SEMGW" AS WACS_Report_Type, tblHoldDepEdd.ClientAnalyteID
FROM tblWacs_Svl_SolidWaste_Testsite_Inventory INNER JOIN tblHoldDepEdd ON (tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_Name=tblHoldDepEdd.ClientSampleId) AND (tblHoldDepEdd.ProjectNumber=tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_ID)
WHERE (((tblHoldDepEdd.ClientAnalyteID) Like "2030" Or (tblHoldDepEdd.ClientAnalyteID) Like "1880" Or (tblHoldDepEdd.ClientAnalyteID) Like "1900" Or (tblHoldDepEdd.ClientAnalyteID) Like "FL-PHYS-007" Or (tblHoldDepEdd.ClientAnalyteID) Like "2055" Or (tblHoldDepEdd.ClientAnalyteID) Like "EPA E1647296" Or (tblHoldDepEdd.ClientAnalyteID) Like "1610") AND ((tblHoldDepEdd.QCType)="N") AND ((tblHoldDepEdd.AnalyteType)="TRG"));


*_Solid Waste (field) EDD without Field Parameters

SELECT DISTINCT tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_ID, tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_Name, tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_ID, tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_Name, "E" AS Sample_Type, "W" AS Matrix_ID, "" AS Field_Measurement_Method, "" AS Field_Parameter_NameAnalyteName, "" AS Result, "" AS Result_Units, "" AS Field_Parameter_Qualifier_Code, "" AS Field_Comments, "" AS Sampling_Personnel, "" AS Collection_Agency, tblHoldDepEdd.DateCollected AS Date_Sampled, tblHoldDepEdd.ShippingBatchID AS Shipping_Batch_ID, "Y" AS Well_Purged_Flag, "SEMGW" AS WACS_Report_Type
FROM tblWacs_Svl_SolidWaste_Testsite_Inventory INNER JOIN tblHoldDepEdd ON (tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_Name=tblHoldDepEdd.ClientSampleId) AND (tblHoldDepEdd.ProjectNumber=tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Facility_ID)
WHERE (((tblWacs_Svl_SolidWaste_Testsite_Inventory.WACS_Testsite_Name) Not Like "*blank*") AND ((tblHoldDepEdd.ClientAnalyteID) Is Not Null) AND ((tblHoldDepEdd.QCType)="N") AND ((tblHoldDepEdd.AnalyteType)="TRG"));


*_Unique LDD_Samples

SELECT DISTINCT tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.DateCollected
FROM tblHoldDepEdd INNER JOIN tblHoldSolidWasteEdd ON tblHoldDepEdd.ClientSampleId = tblHoldSolidWasteEdd.WACS_Testsite_Name
GROUP BY tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.DateCollected, tblHoldSolidWasteEdd.WACS_Testsite_Name, tblHoldDepEdd.QCType, tblHoldDepEdd.AnalyteType
HAVING (((tblHoldDepEdd.ClientSampleId) Not Like "*blank*") AND ((tblHoldDepEdd.QCType) Like "N") AND ((tblHoldDepEdd.AnalyteType) Like "TRG")) OR (((tblHoldDepEdd.ClientSampleId) Not Like "*Blank*")) OR (((tblHoldDepEdd.ClientSampleId) Not Like "*BLANK*"))
ORDER BY tblHoldDepEdd.ClientSampleId, tblHoldDepEdd.DateCollected;