SELECT Max(DataElectricity.Date) AS MaxOfDate, DataElectricity.Point_Id
FROM DataElectricity
GROUP BY DataElectricity.Point_Id
ORDER BY DataElectricity.Point_Id;

SELECT Lookup.Lookup_Name AS [Group], Contacts.Name AS Site, Points.Number AS MPAN, DataElectricity.Date, DataElectricity.M1_Present, DataElectricity.M2_Present, DataElectricity.M3_Present, DataElectricity.M4_Present, DataElectricity.M5_Present, DataElectricity.M6_Present, DataElectricity.M7_Present, DataElectricity.M8_Present
FROM Lookup INNER JOIN (([Qry_LastInv 1] INNER JOIN DataElectricity ON ([Qry_LastInv 1].MaxOfDate = DataElectricity.Date) AND ([Qry_LastInv 1].Point_Id = DataElectricity.Point_Id)) INNER JOIN (Points INNER JOIN Contacts ON Points.Contacts_Id = Contacts.Id) ON [Qry_LastInv 1].Point_Id = Points.Id) ON Lookup.Lookup_Id = Contacts.Group_1
WHERE (((DataElectricity.Direct)="D"))
ORDER BY Lookup.Lookup_Name, Contacts.Name;