I have some simple SQL below to return project details for projects that have been 'parked':
SELECT N0.RADProjectNo, P0.ProjectTitle, S0.StaffName, N0.GLAppDate FROM NPAFRevision AS N0, ProjectMain AS P0, Staff AS S0 WHERE (((N0.RADProjectNo)=[P0].[RADProjectNo]) AND ((P0.PManager)=[S0].[StaffID]) AND ((P0.PStatusID)=4) AND ((N0.RevisionReason) Like 'Project parked:*'))
This is working ok but can return several rows for a single project; what I would like it to do is just return the row (RADProjectNo, ProjectTitle, StaffName and GLAppDate) with the most recent GLAppDate for each project (RADProjectNo)
Could you help please?