mulitple date fields in table

[jem53]

two tables
table 1 contains the following fields:
accession number (primary key)
accession date

table 2 contains the following fields:
record number (primary key)
accession number
status date
bloom (yes/no format)
task type

is there a way to create a query that will return results
for all records in table one and the maximum dates for
both bloom and task type?

the column headings would be something like this:

accession number/accession date/status date/bloom/task type

please 'dumb down' any suggestions you might have. i am
new at this!

thanks, jem

 

[Allen Browne]

This link provides four ways to achieve this:
http://www.mvps.org/access/queries/qry0020.htm