Where clause trouble

[kickballmvp2006]

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.

 

[kickballmvp2006]

I should have mentioned that I want to be able to do that
in addition to what I already have. So I am sorting
and showing all weeks (by weekending date) where MTD_PERC => .15

 

[r937]

just add HAVING MTD_PERC => .15 after the GROUP BY clause



r937.com | rudy.ca

 

[kickballmvp2006]

When I did that, it prompted me to input something for MTD_PERC.

 

[r937]

oh, really????

well, in that case, try it like this --

[red]select * from ([/red]
[blue]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
INNER
  JOIN tblCalendar454 AS b
    ON a.TDate between b.WkStart and b.Wkend
GROUP 
    BY b.WkEnd[/blue]
[red]) as foo
where MTD_PERC => .15[/red]

r937.com | rudy.ca