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.firstnameThanks