Hi There ...
Using This Query for an Access DB
SELECT SUM(steps) AS TotalSteps, COUNT(DISTINCT email) AS TotalEmails FROM steps WHERE week = 1
I get this error ...
Syntax error (missing operator) in query expression 'COUNT(DISTINCT email)
Can you have a SUM and COUNT in the Same Query?
Thanks ... I just thought I would ask
You can't Count(DISTINCT field) . . .