query won't run

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am writing a query that won't run in Access:

SELECT COUNT(DISTINCT enroll.grade)
FROM Enroll
where enroll.grade = 4.0

I would like it to return the number of distinct 4.0's in the table, but I
get a syntax error. The only way it will run is if I move DISTINCT in front
of COUNT, and then it returns the same result set that it does if I leave
DISTINCT out altogether. Does anyone know why?
Thanx,
Rip
 
Try two queries. Get the DISTINCT you want in the first query then base the
Count query on the first one instead of directly on the table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

perform INNER JOIN on query results 2
how do i perform a Count(Distinct) query for 2 different column va 1
Totals Query with Multiple Counts 3
Writing A Select Statement To Return a Count Of Unique Dates In aTable 2
Case Sensitive Query 2
COUNT and DISTINCT in Access 3
wish there was a CountDistinct() function 6
SELECT DISTINCT query 8

Back
Top