Find Duplicates Wizard giving me an error

[Sephaerius]

I'm using the Find Duplicates Wizard and it won't allow me to create a table from the results because it says that "The expression you entered is missing a closing parenthesis, bracket, or vertical bar."
Well, Access is the one who wrote the expression - why did it write a faulty one, and how do I correct it? The data that this query generates appears to be correct, so it's functioning as I intended. Here's the duplicate criteria, if anyone can locate where the missing parenthesis, bracket, or vertical bar is, I would really appreciate it!

IN 
(
SELECT[Total Hours Check, Excluding Non-Productive Time/Time Off (calcu]
FROM[duplicates]AStmp
GROUPBY[Total Hours Check, Excluding Non-Productive Time/Time Off (calcu],
[Total Productive Hours Worked per day (manual entry)*],
[Name],
[Date],
[Client],
[COE]
HAVINGcount(*)>1
AND[Total Productive Hours Worked per day (manual entry)*]=[duplicates].[Total Productive Hours Worked per day (manual entry)*]
AND[Name]=[duplicates].[Name]
AND[Date]=[duplicates].[Date]
AND[Client]=[duplicates].[Client]
AND[COE]=[duplicates].[COE])

[ranman256]

AStmp is 2 words: AS TMP
HAVINGcount is 2 words : HAVING COUNT(

You shouldn't name fields with commas, brackets, slashes, asterisks.

[Sephaerius]

AStmp is 2 words: AS TMP
HAVINGcount is 2 words : HAVING COUNT(

You shouldn't name fields with commas, brackets, slashes, asterisks.

I don't know why the formatting took out the spaces, but yes those appear as two words. As for the field names, I don't control those, but I suppose I could create a temporary tables with corrected field names for this purpose. I'll give that a try and see, thanks!

EDIT: That did the trick, it seems. So obvious, yet I missed it. Thanks again.