Create report with EARLIEST date for several different participant

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that shows EACH participant's records with dates of an
event. How do I create a report that includes those records with the
EARLIEST date for EACH participant.
I can use TopValue if I limit query to ONE participant's records, but I
need to retrieve the records of many participants' topvalue.

TIA
Sfkent
 
You will need a two step query. The first should find the max date per
participant. Next link the results of the first query to the current query

Good Luck,
 
I have a query that shows EACH participant's records with dates of an
event. How do I create a report that includes those records with the
EARLIEST date for EACH participant.
I can use TopValue if I limit query to ONE participant's records, but I
need to retrieve the records of many participants' topvalue.

TIA
Sfkent
Click to expand...

Try this:
http://www.mvps.org/access/queries/qry0020.htm

I use it pretty often now. I prefer solution 4, myself.

HTH,
RD
 
Thanks. Much appreciated.
Steve Kent

Datasort said:
You will need a two step query. The first should find the max date per
participant. Next link the results of the first query to the current query

Good Luck,
Click to expand...
 
Back
Top