Aug 15 2008, 05:23 AM
Is there any way you can run a query to find the same data in the same field?
eg these emails all appear in the same column email@example.com@firstname.lastname@example.org@email@example.com@firstname.lastname@example.org@email@example.com
how would I return the emails that are more than one instance so e.g. firstname.lastname@example.org@test.co.uk
I have tried running a query asking for where count is <2 and also have tried where email address <2
cant really think of anything else to try?
Aug 15 2008, 05:41 AM
Is there a reason why the Find Duplicate Query Wizard is not working for you?
Aug 15 2008, 05:46 AM
Or even a total & group query asking for a count of each and setting a criteria of >1..
Aug 15 2008, 06:07 AM
In the past I have had issues with the find duplicate wizard as I thought I would need to have the data in two different columns? Is there a way of doing this if all the data I need to sort through is in the same field?
Aug 15 2008, 06:10 AM
Whenever I try to do a 'group by' and set the criteria of >1 access updates it to >'1'
Ah This should be simple! :(
Aug 15 2008, 06:15 AM
Have you added that extra column in the T&G query and set it to "Count".. this should return a numerical values and you criteria is set against that..
Aug 15 2008, 07:13 AM
In the design query page, Ive added another 'email address' field and have set that to 'count' and set to >2. Ive asked for it not to be shown. I have also left in another 'email address' and left it to be shown. This now shows nothing! :( any ideas?
Aug 15 2008, 07:43 AM
The email field should be in the query twice. In the first column, the "Total:" should be a Group By. In the second column the Total: should be a "Count" and the criteria should be >1.
Aug 15 2008, 08:00 AM
Thanks you to all of you. Ive now got this working. Thank you. I think I had issues with the naming convention and once this was sorted the count query worked. i thought I was going mad. Thanks!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here