Data structure to look for dupe numbers

[bulrush]

Access 2003 on Win XP.

Is there a built-in object in A2003 which will allow me to search a recordset, to look for records that have the same numeric (4 digit) number in a field called "PLU"?

The field in my recordset "PLU" is actually a string which contains 1 or more 4 digit numbers separated by commas.

An array just seems clumsy and slow.

Thanks.

 

[RuralGuy]

Have you tried the Duplicate Record wizard and modified the query to use InStr()?

 

[bulrush]

No. Does the Duplicate Record wizard search on a given field?

Here are the possible contents of my PLU field:
1111
2222, 1111
1234, 4557, 8899

For my purposes, the first and second records should pop up as containing the same PLU of "1111".

Also, can the Duplicate Record wizard be set up to be run from a command button?

 

[RuralGuy]

Use the wizard and create the query and then look at the SQL view of the query.