|
| |
|
|
DesiMcK
Posts: 445
Joined: 4/26/2004
From: Essex, UK
Status: offline
 |
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
Posts: 445
Joined: 4/26/2004
From: Essex, UK
Status: offline
|
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
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
