Finding data for the latest date

[Guest]

Hi again,
Ok, new question. I need to find information for the last milestone passed.
Now I have a table like this
Main table:
ID | Other stuff ....

Secondary table

ID | MILESTONE | DATE PASSED
1 1 1/20/98
1 2
1 3

The Only indication that a milestone has been passed is if there is a date
in the DATE_PASSED field. So I need a query that displays:

ID | Other info | Last Milestone passed

Now there is a possible that none of the milestones have been passed, in
which case i would just like a NULL field to appear. Any help in doing this
in the query editor or SQL will be awesome. Thanks


Mark

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
for 4 ways to handle this.