First and foremost, I'm a fairly novice user.
I want to create a database that tracks a cross country team. Data I want to manage includes athletes, their race times at each meet, PRs, mile splits, and historical data from prior years' meets.
I've started a basic database with a few tables to capture the basic data: roster with ages and race distances they run, meet list, results from one meet.
I would like to create a query that would predict race performance based on mile splits. And also display current PRs compared to prior year PRs.
I've tried to create a query that would calculate 'Race Distance' * 'Mile Split 1' to calculate predicted race time, but I'm getting a formatting error that's not showing me minutes : seconds.
I've done a lot of this in Excel already, but of course if I alter a sheet the formulas error out.
Right now I don't have a ton of data to enter, but that will change as time goes on.
I'd appreciate any help.