HAVING clause should work in this case.

SELECT COUNT(dbo.meetproc.procid) AS ProcCount,
	dbo.coper.lastname,
	dbo.coper.firstname,
	dbo.meetproc.procid,
        dbo.coproc.description, 
        dbo.coproc.ActivityAlertLevel
...
HAVING COUNT(dbo.meetproc.procid) >= dbo.coproc.ActivityAlertLevel

>I'm hoping to limit the query below to return only records who's ProcCount is equal to or greater than the coProc.ActivityAlertLevel value. Any help appreciated.
>
>

>declare @ltQueryFrom datetime
>declare @ltQueryTo   datetime
>
>set @ltQueryFrom = '10/01/2002 00:00:00'
>set @ltQueryTo   = '10/31/2002 23:59:59'
>
>
>SELECT COUNT(dbo.meetproc.procid) AS ProcCount,
>	dbo.coper.lastname,
>	dbo.coper.firstname,
>	dbo.meetproc.procid,
>        dbo.coproc.description
>FROM    dbo.meetings INNER JOIN
>        dbo.meetproc ON dbo.meetings.meetingnumber = dbo.meetproc.meetingnumber INNER JOIN
>        dbo.coper ON dbo.meetproc.coperid = dbo.coper.coperid INNER JOIN
>        dbo.coproc ON dbo.meetproc.procid = dbo.coproc.procid
>WHERE     (dbo.meetproc.coperid > 0)
>	AND (dbo.meetings.iscancelled = 0)
>	AND (dbo.coproc.ActivityAlertLevel > 0)
>	and meetings.Begintime between @ltQueryFrom and @ltQueryTo
>GROUP BY dbo.coper.coperid, dbo.coper.lastname, dbo.coper.firstname, dbo.meetproc.procid, dbo.coproc.description
>ORDER BY dbo.coper.lastname, dbo.coper.firstname
>

>
>Thanks
>Kirk