Hi people,
I want to make a query where I can find duplicate cells. But the query must not check the complete cell. Just the first 12 characters in the cells must be checked on duplicate values. Below you can see my tabel. For example:
must be marked as duplicate.
must be marked as duplicate
TABEL
I tried criteria:
In (SELECT [Name] FROM [locations gemeente amsterdam - EXPERIMENT] As Tmp GROUP BY [Name] HAVING "Duplicate" )
But this one is checking the complete cell. That's not what I want, I just want a first 12 characters check.
The Query wizard is not giving that option.
Do you have any idea?
I want to make a query where I can find duplicate cells. But the query must not check the complete cell. Just the first 12 characters in the cells must be checked on duplicate values. Below you can see my tabel. For example:
NL_1102CW_150___AMSTERDAM |
NL_1102CW_150___AMSTERDAM ZUIDOOST |
NL_1105AG_10___AMSTERDAM |
NL_1105AG_100___AMSTERDAM ZUIDOOST |
NL_1105AG_100A___AMSTERDAM ZUIDOOST |
TABEL
Name |
NL_1101ED_20Vri___AMSTERDAM |
NL_1102BR____AMSTERDAM |
NL_1102CW_150___AMSTERDAM |
NL_1102CW_150___AMSTERDAM ZUIDOOST |
NL_1105AG_10___AMSTERDAM |
NL_1105AG_100___AMSTERDAM ZUIDOOST |
NL_1105AG_100A___AMSTERDAM ZUIDOOST |
NL_1105AG_1___AMSTERDAM ZUIDOOST |
I tried criteria:
In (SELECT [Name] FROM [locations gemeente amsterdam - EXPERIMENT] As Tmp GROUP BY [Name] HAVING "Duplicate" )
But this one is checking the complete cell. That's not what I want, I just want a first 12 characters check.
The Query wizard is not giving that option.
Do you have any idea?