New Database with a question on relationship

[Madmax]

Good morning fellow access users,
I am currently working a new DB that I have a question about. This is for tracking physical training for a military squadron. I have my table for each person (PT_ID) and I have a table for each PT test(PT_Test). Now on the PT_Test table, I have the following fields:
Table Key(Formulated from excell)
DBPTID (the ID of the person doing the test. this is relationshiped to the PT_ID Field)
Body Mass Index
Weight
Height
Test Date


Cardio
Abdo circ
Pushups
Sit-ups
Mode
Score
Test due (Not needed)
Fitness Level

What I am wanting to do is use the most recent record for each person to plug in their current test date, score, and fitness level. This way when you bring up their name it shows only the most recent Record from the PT_Report table. Once I have the code I will use it in both queries and forms to do most of the interactions. But when I pull a person's name I want their most recent report on the form not all the records. The rest I can do using calculations, relationships, and so on.

Thoughts?

[TheShabz]

In the query design window, select everything you want and turn on the aggregate function (the sigma sign). Leave everything at GroupBy but change the Test Date to "Max". That will give you the highest date for each DBPTID. You can then set the criteria for DBPTID to a form control and get just that one person.

[Madmax]

thank you, that is perfect!