get most recent date for each test?

[yepwingtim]

I have a Date and a Test Field

Is it possible for me to get every test with its lastest date on it only?

Lets say we have

2/13/08 CityTest 90%
1/4/07 CityTest 76%
1/2/07 CityTest 50%
1/5/04 Quiz 40%
1/2/04 Quiz 75%
1/5/09 Exam 50%

I would only like

2/13/08 CityTest 90%
1/5/04 Quiz 40%
1/5/09 Exam 50%

to appear on my report

thanks guys =D
________
HAWAII MEDICAL MARIJUANA DISPENSARY

 

[pbaldy]

This type of thing?

http://www.baldyweb.com/LastValue.htm