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.
 
Back
Top