I have historical data on our schools races, for each day of competition in a race there are:

Student name

date

lowest time

highest time

start run time

end run time

number of runs

I dont know how to relate this data for multiple days for each student? I have one record per student and all the calculations set up but I am lost on how to join day 1 times, to day 2 times for a student so that I can compute the percent increase. I have attached the file so you can see what I have done. Any help would be great!

school_st.zip

What you need is at least two tables in your database. One for students - this would hold their name and any other info personal to the student. A second table that holds the race information. Each race record would contain the studentID of the student it belongs to. Relate the two tables by this student id. Each student can then have mulitple race records (one for each day). This will lead you on the right path to your future goals of analyzing race data by student.

This kind of need has come up in the past. I not sure if it the discussions were the same as your need, but here are a couple of thread that had files.

http://fmforums.com/forum/showtopic.php?tid/145152/post/145152/#145152

http://fmforums.com/forum/showtopic.php?tid/155846/post/155846/#155846

There are some other files that were race related, maybe if you do a search for Race Result, or Race Time, etc. you can pull more up.

HTH

Lee