Selecting the most recent record

[Bakema]

I have asked this question before, but did not get a
response.

How do I design a query that returns the most recent
record of each child and their current school from a set
of tables that store information about children and all
the schools they have attended.

Thanks for help.

Bakema

 

[Allen Browne]

There are several ways to do this, depending on your needs.

This article suggests 4 approaches:
http://www.mvps.org/access/queries/qry0020.htm