Report advice please

  • Thread starter Thread starter neil40
  • Start date Start date
N

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
 
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>
 
Back
Top