ASP DB Error

Databases
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?

2

Thanks … I just thought I would ask

3

You can’t Count(DISTINCT field) . . .