Query for most recent date

[benjamin.m.winchester]

I have a single table which stores entries for Fitness Test scores. Each new test is entered with all scores, a date, a TestID and other fields. If someone takes multiple tests, they will have multiple entries in the table (date and testID will be unique (except many people will have the same date)). How do I get the most recent test for each individual and get all other fields reported as well? I have looked through many forums and all solutions return only the name (grouped) and the date (filtered using max function).



Speak slowly, Im a noob and know nothing about SQL. Thanks.

Ben

[ssanfu]

Here is an example of what you want to achieve:

http://www.rogersaccesslibrary.com/forum/topic326.html

[benjamin.m.winchester]

Works great, Thanks!

Now, my boss wants to know if I can show a change between the last two fitness tests. Is it possible to (in a new query) find the second most recent test. I can set up the relationships and do the calculations to determine the change, i just need to generate a recordset that shows the second most recent test scores. Possible?

[June7]

Review http://allenbrowne.com/subquery-01.html#AnotherRecord