error in query

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.
 
G

Guest

could you suggest any other motod tro achieve what i am
looking for ?

thanks for your help.
 
D

Duane Hookom

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