Getting the most recent date.

[gj0519]

Here is what I would like to do.
If Joe has 5 scores with 5 different unknown dates, I want to know how to tell access to give me the most recent date and score associated with it. I have tried numerous things and I can not figure this out.
Thanks,
gj0519

 

[jfgambit]

Create a new Query, hit the Totals button (the funny looking "E" on the toolbar)

Change the GroupBy of the Date field to Max and the Score GroupBy to First.

HTH

"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[rhicks]

I think he will need to Group by the field that identifies the person .. then select Max for the date field in the Totals query.

RDH

Ricky Hicks
Birmingham, Alabama

 

[gj0519]

Thanks, I had everything except the group by option on the score or name.
Thanks,
gj0519