The First is that instead of

where cnt > 1

Should be deleted and after "group by"

just write having count(*)>1

The Second is treaky but, why are you selecting * and the a field that is supposed to be taken from the select statement ?

And by the way Your query is formated in ACCESS SQL not in TSQL

Dates in TSQL are not surrounded by '#'

HTH