I am getting multiple results in my Max query such as this:
I only need the line with the Max date to appear in the report. Here is my query as of now:
SELECT tblContractor.CompanyName ,tblContractor.BMSIContractorID AS [tblContractor_BMSIContractorID] ,tblInsurance.BMSIContractorID AS [tblInsurance_BMSIContractorID] ,Max(tblInsurance.PolicyExpDate) AS MaxPolicyExpDate FROM tblContractor INNER JOIN tblInsurance ON tblContractor.BMSIContractorID = tblInsurance.BMSIContractorID GROUP BY tblContractor.CompanyName, tblContractor.BMSIContractorID, tblInsurance.BMSIContractorID, tblInsurance.PolicyExpDate
I've tried a couple things such as an ON statement after Group By but I'm not thinking clearly on this. Thanks for any help!