Page History

SELECT TBLSample.Station_ID, TBLSample.Sample_CodeTBLStation_Information.Latitude, TBLStation_Information.Longitude, TBLSample.IDLocStart_Date, TBLResults.IDLocResult_Value, TBLParameter_Group.Parameter_Group, TBLParameter_Codes.Full_Name, TBLParameter_Codes.Short_Name,

FROM TBLStation_Information RIGHT JOIN (((((TBLResults INNER JOIN TBLSample ON (TBLResults.Sample_Code = TBLSample.Start_Date, TBLResults.Result_Value, TBLParameter_Group.Parameter_Group
FROM TBLParameter_GroupSample_Code) AND (TBLResults.IDLoc = TBLSample.IDLoc)) INNER JOIN TBLParameter_Codes ON TBLResults.Parameter_Code = TBLParameter_Codes.Parameter_Code) INNER JOIN (TBLQAPP_Group_Codes INNER JOIN (TBLQAPPGroups TBLQAPPGroups ON TBLParameter_Codes.Parameter_Code = TBLQAPPGroups.Parameter_Code) INNER JOIN (TBLParameterTBLQAPP_Group_Codes ON INNERTBLQAPPGroups.QAPPCode JOIN (TBLSample= TBLQAPP_Group_Codes.QAPPCode) INNER JOIN TBLResultsTBLParameter_Group ON TBLSample.Sample_CodeTBLQAPP_Group_Codes.Parameter_Group = TBLResultsTBLParameter_Group.SampleParameter_CodeGroup) ON TBLStation_Information.Station_ID = TBLSample.Station_ID

WHERE (((TBLParameter_CodesGroup.Parameter_Code = TBLResults.Parameter_Code) ON TBLQAPPGroups.Parameter_Code = Group)=9 Or (TBLParameter_Group.Parameter_Group)=10));