Error on A Query

[Guest]

I am using this:

SELECT T1.*

FROM YourTable AS T1
WHERE
(SELECT COUNT(*)
FROM YourTable AS T2
WHERE T2.Identifier = T1.Identifier
AND T1.Type = T2.Type) > 1;

I get the following error message:

"The Microsoft Jet database engine does not recognize 'T1*' as a valid field
name or expression"

Not sure what to do next.

Thank you in advance.

 

[Tom Ellison]

Dear Carl:

I cannot see anything wrong with the query. I copied it into a database I
have, changed the table name and the two column names, and it runs fine.

You may have a corrupted database. Run compact and repair on the database
WHERE THE TABLE IS (if it is linked, you must compact and repair there!)

Please let me know if this helped.

Tom Ellison