E
ewb
How do you create a query that will yield the latest
record from one table for each person in another table?
record from one table for each person in another table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
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