On Fri, 19 Oct 2001 10:16:26 -0400 (Eastern Daylight Time), David Ebert wrote:
>by), but I'm having no luck trying to figure out how to count the records in >the clients table for the unduplicated count of open cases for each service >week. Dave, Would the DISTINCT keyword help? Something like SELECT weeknumber, + COUNT (DISTINCT casenum) AS TotalCases, +.. COUNT (DISTINCT clientid) AS TotalClients + FROM whatever + WHERE statuscode = 'open' + GROUP BY weeknumber
