mdumka — 2010-09-23T15:30:48-04:00 — #1
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?
mdumka — 2010-10-05T16:29:36-04:00 — #2
Thanks ... I just thought I would ask
wwb_99 — 2010-09-23T17:59:04-04:00 — #3
You can't Count(DISTINCT field) . . .