Dear all,
I am having a nightmare trying to crack this problem:

I have a risk table where I record the basic details of a risk. I then have a 1:M relationship with two tables called risk assessment and risk actions.

A risk can have many assessments and many actions, both these tables are independent of each other.

Therefore if I assess a risk 3 times on dates(us format) 11/01/01, 11/10/01 & 11/21/01 I only wish to show risk assessment date for 11/21/01.

I put all the fields in the query grid but I just can't crack the criteria for returning the last risk assessment date

Thanks
Mark



All times are ET (US)

This may not be the most elegant solution, but it does work. In your query, sort the Risk Assessment date field as descending. In the properties for the query, set Top Values to 1
Hope this helps.

David

If you include the Totals row in the QBE grid, (Sigma letter on the tool bar) you can have it return the Max of that fields value.

Please don't post the same question under multiple topics.