Last Record query

  • Thread starter Thread starter ewb
  • Start date Start date
E

ewb

How do you create a query that will yield the latest
record from one table for each person in another table?
 
You need to join the tables on the proper key field, select the fields
you want to see, then use a Group By query, grouping by Person and
returning Max for Dates (you can do that using the Totals row on the
query designer grid). Save this query, then join it back to the table on
both Person and Date, and return all fields.

Pavel
 
Back
Top