mark curtis
Registered User.
- Local time
- Today, 14:47
- Joined
- Oct 9, 2000
- Messages
- 457
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
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