Calculate historical rating (was Help With Access Development)

[Nobber]

Hi I am new on the forum. I use Access for generating my own Horse race cards whereby each horse is assigned a rating to which it is predicted to run on that day. I can do this myself following some pain and hard work.

The rating to which the horse is assigned is based on the best Actual rating over the past 10 races and within the last year.

What I now need to do is check the result restrospectively. In Order to do this I need to add an additional field which includes the horses predicted rating on that particular day.

I am looking for someone to help me develop this so that I can analize historic results.

Can anyone give me a steer as to how best to move my project forward.

Thanking you in anticipation

Nobber

[pbaldy]

How would you calculate it for today? It should the same, but passing a date parameter to get the appropriate races to calculate on.

[Nobber]

Hi Pbaldy to calculate todays ratings I put in a date today < 365 (days) and then rank the ratings into top ten and choose the higest rating. This gives the horse a rating it is expected to run to today based on its best performance over the past 10 runs. This data is taken from the performance table.

I need to add an extra calculation to the performance table which looks up the horses previous ratings and calculates it the same way as I described above.

I am new to Access so using the correct termonology is difficult

Thanks for the reply

[pbaldy]

You seem to want a specific answer to a generic question. Instead of basing it on today, base it on a specific date entered by the user. I'd use a form for that. So basically instead of saying "today < 365" you're saying "given date < 365".