Complex group and sort query to find top record for each group

[pb100]

Hi, I have 2 tables, a project table and project status table. My project
status table has a record for each time the status of the project was changed
(i.e. prospecting, active, overbudget, closed). I want to be able to run a
query to show each unique project and its current status. The Project Status
table contains a primary key, project id, status, and date. I know I can
select the top record sorted by date descending for a single project but how
can I run a query to show all the projects and their current status?

Thanks so much!

 

[pb100]

I've answered my own question - found a thread with this link using cascading
queries or a sub-select query:
http://www.mvps.org/access/queries/qry0020.htm. It is about getting the
latest borrower for a book in the library. The only caviat is that I needed
to change my default value for my date field to Now() so that time is
included. Otherwise, if there are two entries with the same date, it does
not return the right data.