Hi All,
I have created a database that I need to identify the unique users by month.
When is the column that holds the date. I have converted by using YEAR and MONTH and I need to do a count a unique count of USERUUID
This is the code I have used so far but keep getting syntax errors.
Any help is appreciated.SELECT Year([When]) AS [YEAR], Month([When]) AS [Month], Count(qry1_UserUuid_Removal.USERUUID)FROM (SELECT Year,
Month,
USERUUID
From qry1_UserUuid_Removal
GROUP BY Year([When]),
Month([When]) AS T
Cheers
DeanMcK