Place Payoff not equal to Zero

[Victor]

Horse finishes first or second but there was no place betting.
What's the best way to handle this? Leaving the race in the query results in an understatement of R.O.I.

Another possibility, suppose the race is a non-betting event, in this case, I could just write: nAODD > 0

[Donnie]

Victor--
unless you like to compare apples to oranges (and the occasional banana) I would toss that race out. If there is no place wagering, then there is no reason to count it in that category.

[Victor]

I want to exclude these races. Can I do this by writing some formula into the query?

Thanks.

[Donnie]

On the criteria line put the date for the date criteria, the proper track code for the proper track and under the race column put <>3, which gives you everything except race three for that date and that track. Make sure they are all on the same row for criteria and you are writing an "AND" statement. TRK and DATE and <>3 (not equal to race 3).

[Victor]

Thanks Donnie,

There are 13 of these races in my database and if I exclude them the R.O.I goes from -2.9% to -2.2% :eek:

No sense "underestimating" my advantage . . . :D