Advertisement
Advertisement
| 07.16.2008 at 06:31AM PDT, ID: 23569536 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: |
SELECT m.month, Count(L.RightFirstTime) AS Total FROM tbl_Lacquer_Mix AS L, tbl_month as m WHERE ((L.DateTime) Between [start] And [end]) AND ((M.MonthId)=Month([L].[DateTime])) group by m.month; SELECT m.month, Count(L.RightFirstTime) AS Pass FROM tbl_Lacquer_Mix AS L, tbl_month as m WHERE ((L.DateTime) Between [start] And [end]) AND ((M.MonthId)=Month([L].[DateTime])) and (l.RightFirstTime = "PASS") group by m.month; |