The first expression is designed to display all past races in the 
StarterHistory table for each of  the horses in the StartersToday 
table for BEL R1 on 10-13-2016 and uses "ORDER BY STARTERHISTORY.PACEPRESSURE DESC" 
(without the quotes) to sort the records by pacepressure in descending order.


SELECT STARTERHISTORY.[DATE], 
       STARTERHISTORY.TRACK, 
       STARTERHISTORY.RACE, 
       STARTERHISTORY.INTSURFACE, 
       STARTERHISTORY.DIST, 
       STARTERHISTORY.HORSENAME, 
       STARTERHISTORY.PACEPRESSURE,
       STARTERHISTORY.ODDS, 
       STARTERHISTORY.OFFICIALFINISHPOSITION, 
       STARTERHISTORY.WINPAYOFF, 
       STARTERHISTORY.PLACEPAYOFF,
       STARTERHISTORY.SHOWPAYOFF FROM STARTERHISTORY
       INNER JOIN STARTERSTODAY ON STARTERHISTORY.HORSENAME = STARTERSTODAY.HORSENAME
       WHERE STARTERSTODAY.TRACK='BEL'
       AND STARTERSTODAY.RACE = 1            
       AND STARTERSTODAY.[DATE] = #10-13-2016#           
       ORDER BY STARTERHISTORY.PACEPRESSURE DESC



--------------------------------------------------------------


The second expression is designed to display all past races in the StarterHistory table 
for each of  the horses in the StartersToday table for BEL R1 on 10-13-2016 and uses 
"ORDER BY STARTERSTODAY.RAILPOSITION ASC, STARTERHISTORY.PACEPRESSURE DESC" 
(without the quotes) to sort the records first by horse order in the gate from the rail 
out - followed by pacepressure in descending order.


SELECT STARTERHISTORY.[DATE], 
       STARTERHISTORY.TRACK, 
       STARTERHISTORY.RACE, 
       STARTERHISTORY.INTSURFACE, 
       STARTERHISTORY.DIST, 
       STARTERHISTORY.HORSENAME, 
       STARTERHISTORY.PACEPRESSURE,
       STARTERHISTORY.ODDS, 
       STARTERHISTORY.OFFICIALFINISHPOSITION, 
       STARTERHISTORY.WINPAYOFF, 
       STARTERHISTORY.PLACEPAYOFF,
       STARTERHISTORY.SHOWPAYOFF FROM STARTERHISTORY
       INNER JOIN STARTERSTODAY ON STARTERHISTORY.HORSENAME = STARTERSTODAY.HORSENAME
       WHERE STARTERSTODAY.TRACK='BEL'
       AND STARTERSTODAY.RACE = 1            
       AND STARTERSTODAY.[DATE] = #10-13-2016#           
       ORDER BY STARTERSTODAY.RAILPOSITION ASC, STARTERHISTORY.PACEPRESSURE DESC


--------------------------------------------------------------


I'm thinking the third expression is probably closer to what you had in mind in your email.

This one is designed to display all past races in the StarterHistory table for each of the 
horses in the StartersToday table for BEL R1 on 10-13-2016 and uses 
"ORDER BY STARTERSTODAY.RAILPOSITION ASC, STARTERHISTORY.PACEPRESSURE DESC" 
(without the quotes) to sort the records first by horse order in the gate from the rail out 
- followed by pacepressure in descending order.


SELECT STARTERHISTORY.[DATE], 
       STARTERHISTORY.TRACK, 
       STARTERHISTORY.RACE, 
       STARTERHISTORY.INTSURFACE, 
       STARTERHISTORY.DIST, 
       STARTERHISTORY.HORSENAME, 
       STARTERHISTORY.PACEPRESSURE,
       STARTERHISTORY.ODDS, 
       STARTERHISTORY.OFFICIALFINISHPOSITION, 
       STARTERHISTORY.WINPAYOFF, 
       STARTERHISTORY.PLACEPAYOFF,
       STARTERHISTORY.SHOWPAYOFF FROM STARTERHISTORY
       INNER JOIN STARTERSTODAY ON STARTERHISTORY.HORSENAME = STARTERSTODAY.HORSENAME
       WHERE STARTERSTODAY.TRACK='BEL'
       AND STARTERSTODAY.RACE = 1            
       AND STARTERSTODAY.[DATE] = #10-13-2016#           
       ORDER BY STARTERSTODAY.RAILPOSITION ASC, STARTERHISTORY.PACEPRESSURE DESC


--------------------------------------------------------------


-jp

.