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