Report advice please

I have a table that is a series of event results over the years.

I have reports that for example show event by event 1st place to 10th
etc.

I would like to create a report that shows a single persons record over
the years.

So, I want to be able to pick from a list of competitors (which
naturally builds as more and more competitors are added to the table),
and when the name is selected, run a report that lists that persons
'events'

I imagine I need to create a query that pulls in all the results from
the table, and somewhere have a drop down list to select my
'competitor' from

I'd like some advice please as to the best method of creating this.

Thanks
Neil

Neil

If you want to be able to select a single competitor, use a combo box in a
form. Modify the query that underlies your report to point to the combo box
on the form to find the criterion (i.e., which competitor).

Regards

Jeff Boyce
Office/Access MVP

wrote in message
oups.com...
I have a table that is a series of event results over the years.

I have reports that for example show event by event 1st place to 10th
etc.

I would like to create a report that shows a single persons record over
the years.

So, I want to be able to pick from a list of competitors (which
naturally builds as more and more competitors are added to the table),
and when the name is selected, run a report that lists that persons
'events'

I imagine I need to create a query that pulls in all the results from
the table, and somewhere have a drop down list to select my
'competitor' from

I'd like some advice please as to the best method of creating this.

Thanks
Neil