SQL QUERY - Duplicate

[fluffyvampirekitten]

My current code is to extract all those data with duplicate /same name , dob , gender and postal code .

SELECT *
FROM CrossSystemData
WHERE (((CrossSystemData.C_SOURCE)
IN 
( SELECT [C_SOURCE] FROM [CrossSystemData] As tmp
GROUP BY [C_SOURCE] , [POSTAL_CODE] , [DOB] , [NAME] , [GENDER] HAVING COUNT(*) > 1 AND 
[POSTAL_CODE] = [CrossSystemData].[POSTAL_CODE] AND [DOB] = [CrossSystemData].[DOB] AND
[NAME] = [CrossSystemData].[NAME] AND [GENDER] = [CrossSystemData].[GENDER]) AND
(CrossSystemData.C_SOURCE)=("EPOS")))
ORDER BY CrossSystemData.C_SOURCE, CrossSystemData.POSTAL_CODE, CrossSystemData.DOB, CrossSystemData.GENDER, CrossSystemData.NAME;

I need to compare the data in the row against the data in the other row, and I'd like to use LIKE to compare the name
I would like to extract those date with same dob , gender and postal code but the with similar ( alike) . However , I have no idea how to do it .

SELECT *
FROM CrossSystemData
WHERE (((CrossSystemData.C_SOURCE)
IN 
( SELECT [C_SOURCE] FROM [CrossSystemData] As tmp
GROUP BY [C_SOURCE] , [POSTAL_CODE] , [DOB] , [NAME] , [GENDER] HAVING COUNT(*) > 1 AND 
[POSTAL_CODE] = [CrossSystemData].[POSTAL_CODE] AND [DOB] = [CrossSystemData].[DOB] AND [GENDER] = [CrossSystemData].[GENDER]) AND
(CrossSystemData.C_SOURCE)=("EPOS"))) AND (CrossSystemData.CATEGORY)=("POTENTIAL DUP")
AND [NAME] LIKE " % [CrossSystemData].[NAME] % "
ORDER BY CrossSystemData.C_SOURCE, CrossSystemData.POSTAL_CODE, CrossSystemData.DOB, CrossSystemData.GENDER, CrossSystemData.NAME;

Trying to do the code above but I did not get any results.

[JeroenMioch]

Try the & symbol.
I have a custom made filter on my form that has a like into it. Its no SQL but you can give it a go i guess.
like '*" & [CrossSystemData].[Name] & "*'"