SELECT * FROM CHARTRACES WHERE TRIPOOL > 0 
AND [RACEDATE] >= #04-01-2016#
AND [RACEDATE] <= #12-31-2016#
ORDER BY [RACEDATE], TRACK, RACE