Find data for 3 most recent records

[Paul Simon]

I have a table which has the fields Name, Date and Pace in which records
for each name can appear many times.

I need to link another table, in which each Name can only appear once, to
the first table and find the 3rd most recent, 2nd most recent and most
recent Pace figure.

 

[John Vinson]

I have a table which has the fields Name, Date and Pace in which records
for each name can appear many times.

I need to link another table, in which each Name can only appear once, to
the first table and find the 3rd most recent, 2nd most recent and most
recent Pace figure.

The TOP VALUES property of a Query can work here. Order By the date
field (which you might want to rename - Date is a reserved word and
Access will get confused!) and set the Top Values property of the
query to 3.

 

[Paul Simon]

Thanks John.

I've tried what you suggested, but it only gives me the three most recent
records.

I wanted the three most recent records for each name.

The TOP VALUES property of a Query can work here. Order By the date
field (which you might want to rename - Date is a reserved word and
Access will get confused!) and set the Top Values property of the
query to 3.