Selecting specific records when have more than one of each type

[CathieF]

I have a table of information about certain patients for various exams. I have a field that calculates Months postOperation. So There are various entries for different times post op for different patients

ex.
Automatic
Record# patient months post op Other Data
1 1 5
2 1 20
3 1 72
4 2 7
5 2 32
6 2 53

I want to choose the information for the last exam (max post op) for each patient. How do I get just the records I am looking for (which can be identified by record #)? Here I would choose Record # 3 and 6. There is no regularity to number of exams per patient or max value for months postop

 

[larmore]

Create a query with all the information you want to see. Make the query a totals tab and then form Post Op pick Max. Group by Patient ID. This will show one record for each patient with the max Post Op. I hope this helps.