JCapper Message Board

JCapper 101
-- Track weight report set up

Home	Register Log In

Track weight report set up

chrisl
6/9/2012
10:41:16 AM

I have been searching for the SQL expression that I need to use the Track weight report. I found it before but just can not find it now. Thanks Chris

jeff
6/9/2012
12:32:51 PM

Dirt routes at BEL, last 15 days:

SELECT * FROM STARTERHISTORY WHERE TRACK='BEL'
AND INTSURFACE = 1
AND DIST >= 1760
AND DATEDIFF('D', [DATE], NOW()) <= 15

Dirt routes at BEL, all starters June 01, 2012 or later:

SELECT * FROM STARTERHISTORY WHERE TRACK='BEL'
AND INTSURFACE = 1
AND DIST >= 1760
AND [DATE] >= #06-01-2012#

Substitute values for track, intsurface, dist, number of days, or actual date as needed - and break the data out in the Data Window by Track Weight Report.

-jp

.

~Edited by: jeff on: 6/9/2012 at: 12:32:51 PM~

chrisl
6/9/2012
1:06:21 PM

Thank You Jeff..Chris

JCapper Message Board

JCapper 101 -- Track weight report set up

JCapper 101
-- Track weight report set up