Limit The Results To 1 Record Per Job

I'm currently trying to create a KPI report (Key Performance Indicator) to log jobs & their response times

I can easily produce a query that gathers all the information needed but I need to find a way to limit the results to 1 record per job as one job can have many records - Primary key being the TaskID field

I need a way to only pick out the oldest record & ignore the rest

For example


A priority 1 job that was logged at 01/05/2008 08:00 that needs to be responded to within 2 hours

Two engineers have carried out the work & logged the following details

1st Engineer responded at 01/05/2008 09:00 and the other returned later to complete the job at 01/05/2008 13:45

I need the query to only pick out the entry for 01/05/2008 09:00 as it's the oldest.


Any suggestions would be most welcome

this is what my query looks like at the moment.

SELECT tblTasks.TaskID, tblTasks.DateReported, DateAdd("h",DLookUp("[ResponceTime]","[tblPriorities]","[tblPriorities]![PrID]=" & [PrID]),[DateReported]) AS DueBY, tblTaskTime.TTStarted AS DateStarted, tblPriorities.Priority, tblPriorities.ResponceTime, [DateStarted]-[DateReported] AS Responded
FROM tblBuildings INNER JOIN (tblContracts INNER JOIN (tblPriorities INNER JOIN (tblTasks INNER JOIN tblTaskTime ON tblTasks.TaskID = tblTaskTime.TTLINKTask) ON tblPriorities.PrID = tblTasks.TaskPriority) ON tblContracts.ContID = tblTasks.ContractNo) ON tblBuildings.ProID = tblTasks.BuildingID
WHERE (((tblPriorities.Priority) Not Like "P8*" And (tblPriorities.Priority) Not Like "P5*" And (tblPriorities.Priority) Not Like "P3*" And (tblPriorities.Priority) Not Like "P6*"))
ORDER BY tblTaskTime.TTStarted;


Thanks