Report advice please

[neil40]

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

 

[Jeff Boyce]

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>