Show latest date Help!! (1 Viewer)

[mark curtis]

I have a query that returns all risks for a project including any assessment dates of a risk. Therefore a risk may have several assessment dates (eg)assessed 01/10/00 then reassessed 10/10/00.
What I need to do is only return the risk with the latest assessment date which would be 10/10/00.
What code/criteria can I place in the field RiskAssessedDate so that it will do the above.
Thanks
Mark

 

[chrismcbride]

Mark
Have send a small example DB to you that has a query that will do what you need. The only problem may be the table structure that I use may be different than yours.
Good Luck
Chris