In Access 2k7 I get the following error:
Syntax error (missing operator) in query expression `COUNT(DISTINCT [tab1 replaced with actual table name here].user)`

Maybe my problem is using MS SQL instead of MySQL or SQL? Unfortunately in this case I am stuck with working on a .mdb file.

Thanks, though! Any other solutions?