Need to return last record entered by multiple users to mult. reco

P

Paul

I need to get a query put together that returns the last record entered into
a subdatasheet for a record.
I have a project status database built, but need to be able to build the
query for a report that will allow you to see the last update entered for
each project in the database.
The primary table is 'Projects', the subdatasheet table is 'ProjectDetails'
and they are linked by the 'ProjectID' field.
A given project may have between a single update and dozens of them, but I
only want to return the last one entered for each.

Anyone?
 
Top