I am working with MS Access XP. My SQL book teaches to count the distinct number of something, we should use:
Select Count(Distinct(fieldname)) From tblName. I tried it with my Access and it comes up with the error:


"Undefined function 'Distinct'in expression"
Which is crazy, because Distinct(fieldname) works just fine! What has I done wrong? Is there anyway to solve this thing?

Thanks,
Indra