Find data for 3 most recent records

  • Thread starter Thread starter Paul Simon
  • Start date Start date
P

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.
 
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.
Click to expand...

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.
 
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.
Click to expand...
 
Back
Top