Create report with EARLIEST date for several different participant

[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

 

[Guest]

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,

 

[RD]

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

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

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

HTH,
RD

 

[Guest]

Thanks. Much appreciated.
Steve Kent

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,

 

[Guest]

Thanks, RD. I'll experiment with these.
Steve Kent