Jump to content

Starter Question: historical school data. Please help


This topic is 6561 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6561 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.