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
* Noel