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?