a.mlw.walker
Registered User.
- Local time
- Today, 13:13
- Joined
- Jun 20, 2007
- Messages
- 36
I am trying to do a partial duplication query. this is the code from the SQL view in access
the table filtered1 has 1300 records, under the field Company_Name.
the 7's apparently should get it to compare the first 7 letters, and if the same show me them.
A whats going wrong, its not showing me any, asthough there are none, (which i know there are) and
B. How would i get it to compare the first 7 letters across tables, with fields of the same name?
thanks
alex
Code:
SELECT filtered1.Company_Name
FROM filtered1
WHERE (((filtered1.Company_Name) In (SELECT [Company_Name] FROM [filtered1] As Tmp GROUP BY [Company_Name], Left([Company_Name],7)
HAVING Count(*)>1 And Left([Company_Name],7) = Left([filtered1].[Company_Name],7))))
ORDER BY filtered1.Company_Name;
the table filtered1 has 1300 records, under the field Company_Name.
the 7's apparently should get it to compare the first 7 letters, and if the same show me them.
A whats going wrong, its not showing me any, asthough there are none, (which i know there are) and
B. How would i get it to compare the first 7 letters across tables, with fields of the same name?
thanks
alex
Last edited: