error in query

  • Thread starter Thread starter lavanya
  • Start date Start date
L

lavanya

I use access 2000 and have the following query

SELECT count(distinct book_num), county
FROM TblSAIC_Total_Log
group by county;

this gives me an error
'syntax error (missing operator) in query expression 'count
(distinct book_num)'

the same query goes through without the count aggregate
function.
would appreciate any help.
 
could you suggest any other motod tro achieve what i am
looking for ?

thanks for your help.
 
You might have to do this in two queries. The first selects distinct values
and the second (based on the first) counts the records.
 

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

error in query 2
perform INNER JOIN on query results 2
how do i perform a Count(Distinct) query for 2 different column va 1
COUNT DISTINCT ? 5
Cross tab query 5
Query not working between Excel and Access 2
Totals Query with Multiple Counts 3
Access Dcount (multiple criteria) 3

Back
Top