Hi There,

I am building a database to track the fitness of a group of people. Each time we test the people the information is added to the database. Each player then has a growing number of tests which I need to show in a graph which will illustrate how the person has improved (or not).

I have been able to create a graph showing the information I would like e.g. time achieved and date of test, however the issue I am having is that a graph is created for each test date where I simple need just one graph per person showing all tests dates.

Any suggestions?

Thanks

Check this out for clues as how to organize data properly for charts:

http://www.msaccesstips.com/2007/08/ms-access-and-graph-charts/ (http://www.msaccesstips.com/2007/08/ms-access-and-graph-charts/)
http://www.msaccesstips.com/2007/09/ms-access-and-graph-charts2/