Last Record query

[ewb]

How do you create a query that will yield the latest
record from one table for each person in another table?

 

[Pavel Romashkin]

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