Nested SQL Query - No Clue!!

[Joseph McGarvey]

Hi Folks...
I have two DB table columns: FormName, UserID

The data looks something like this


FormName UserID
ContactForm 2
ContactForm 2
ContactForm 2
ContactForm 2
ContactForm 75
ContactForm 75
DownloadForm 5
DownloadForm 5
DownloadForm 5


I want to return a menu that groups “FormName”, but also groups the unique “UserID” so I get this result in my web page


Form Name # of Unique Submissions
ContactForm 2
DownloadForm 1


This is my query for grouping “FormName” and getting total rows for that form


SELECT FormName, Count(UserGUID) AS [TotalRecords]
FROM Contacts
GROUP BY FormName


How can I nest the count for unique UserID’s?

Thanks!

[Roy Sinclair]

Try this:

SELECT DISTINCT FormName, Count(DISTINCT UserGUID) AS [TotalRecords]
FROM Contacts
GROUP BY FormName