LONG SHOT TRACKS

[Gambler]

If there are 5 tracks in a contest. I would like to know which track had the most longshots in the last 30 days. Any suggestion on how i could determine this. Maybe an access query or Robot.
Thanks for any help
ed

[Rick]

I could run that for you in the longshots report.

Or I could send you a copy of the db and you could figure it out for yourself.

The problem you will run into is tracks that have not been running all of the past month. Maybe just starting the week of the contest.

[Gambler]

I have a 30 day database for most track. My problem is trying to figure out what type of query i would run to find this out. Do you use a query or something else? If you think it might be to difficult for me understand, i will forget it.
I got to go to bed now its been a long day, so i wont read your reply until tomorrow.
Thanks Rick
ed

[Rick]

I use three queries.

I use an HX2 export cause it has what I need.

I remove all races under 4.5 fl.

I remove all race lines where xWIN=0.

Of course when you do it you only need to enter the tracks you want with the dates you want for each track. At least that would be the way I would suggest you do it.

Otherwise you could take the queries and modify them for your needs.

[Gambler]

Soon as i can ill give it a try.
Thanks Rick
ed