Hi Set,

>I don't quite grasp your structure, so it is difficult to give sound

advice. How is COMMUNICATIONS and INCIDENT defined, what is their

>relationship and approximately how many records are there within each

table and for each customer?
Just answered in reply to Helen's mail, but in short:

Table Records
Customers 15000 PK ID
Incidents 150000 PK ID, CustomerID references Customers.ID
Comms 1500000 PK ID, IncidentID references Incidents.ID

Need to extract max date in Comms per Customer