Count Distinct Error

[Wile_E]

Hi,

im trying to get a count of the unique customers in an access 2010 database

after some research it seems i should be using

SELECT Count(Distinct [Customer]) FROM [tblMain];

but when i use this i get

Syntax error (missing operator) in query expression 'Count(Distinct Customer)'.

i have tried leaving out the square brackets but this does not help

any idea what im doing wrong

thanks

 

[Minty]

I think it should be SELECT DISTINCT Count(.....

 

[Wile_E]

Thats it thanks

for some reason when i looked online it was written as i had it

seems Google does not know everything after all

 

[JHB]

Thats it thanks

for some reason when i looked online it was written as i had it

seems Google does not know everything after all

I think you forgotten to specified it should be used in a MS-Access.