Finding Duplicate Records
Posted on 2004-08-19
I have an MS Access form that I'm using for a search interface where users select fields from drop down boxes and type their criteria in a text box, which is pretty basic. When they click the Search Button I read their input and build it into a filter string (i.e. Field1 like 'userinput' AND Field2 like 'userinput2' ... etc. ). I then use the Docmd.Appyfilter to filter my records based on the filter string.
However, I am now trying to let the user input a only a number and a field. This number correlates to the number of times data in that field must be repeated.
For example, lets say in my table I have a field called "Field1", and the user enters 10 as the number. I need to build a filter string that will return only the records that have the data in Field1 repeated 10 times.
I can do this by looping through the recordsets, however that is not what I'm trying to accomplish. I'm trying to do it by building a filter string so that I can do it all in one command.
Any help would be greatly appreciated....