Count Distinct (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

DesiMcK -> Count Distinct (4/19/2008 11:51:14)

Does anyone know a workaround for COLUNT DISTINCT for Access.

I have tried the following sql but I need it to return only a count of the distinct TaskIDs.

Thanks,

Desi 
fp_sQry="SELECT COUNT(tblHomework.TaskID) AS myCount, tblHomework.ClassID, tblClass.Subject, tblClass.Teacher FROM tblHomework "
fp_sQry=fp_sQry&"INNER JOIN tblClass ON tblHomework.ClassID = tblClass.ClassID GROUP BY tblHomework.ClassID, tblClass.Subject, tblClass.Teacher"



DesiMcK -> RE: Count Distinct (4/20/2008 3:40:20)

Hi all,

I solved it. This was the SQL:

SELECT
x.TaskID,
COUNT(*) AS myCount
FROM
[
SELECT DISTINCT
h.TaskID,
h.ClassID,
c.Subject,
c.Teacher
FROM tblHomework AS h
INNER JOIN tblClass AS c ON h.ClassID = c.ClassID
]. AS x
GROUP BY
x.TaskID



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875