I have tried changing the properties in my query to Unique Record 'Yes' - which makes the SQL look like this...
SELECT DISTINCTROW Tbl_Correspondence.CorrRef, Tbl_Correspondence.CompanyRef, Tbl_Company.Company, Tbl_Correspondence.DateOfCorr, Tbl_Correspondence.TimeofCorr...