kickballmvp2006
Technical User
Here is my query:
SELECT
b.wkend, round(sum([a.HC_GO]+[a.HP_GO]+[a.AX_GO]+[a.DI_GO]+[a.MV_GO]+[a.CH_GO]+[a.Or_GO])/sum([a.HC_GT]+[a.HP_GT]+[a.AX_GT]+[a.DI_GT]+[a.MV_GT]+[a.CH_GT]+[a.Or_GT])*100,2) AS MTD_PERC
FROM WkTotOff AS a, tblCalendar454 AS b
WHERE a.TDate between b.WkStart and b.Wkend
GROUP BY b.WkEnd;
This query gives me good data.
Now I want to say where MTD_PERC => .15
How would I do that?
Help is much appreciated.
SELECT
b.wkend, round(sum([a.HC_GO]+[a.HP_GO]+[a.AX_GO]+[a.DI_GO]+[a.MV_GO]+[a.CH_GO]+[a.Or_GO])/sum([a.HC_GT]+[a.HP_GT]+[a.AX_GT]+[a.DI_GT]+[a.MV_GT]+[a.CH_GT]+[a.Or_GT])*100,2) AS MTD_PERC
FROM WkTotOff AS a, tblCalendar454 AS b
WHERE a.TDate between b.WkStart and b.Wkend
GROUP BY b.WkEnd;
This query gives me good data.
Now I want to say where MTD_PERC => .15
How would I do that?
Help is much appreciated.