Hi guys

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

1@test.co.uk
1@test.co.uk
2@test.co.uk
3@test.co.uk
4@test.co.uk
5@test.co.uk
5@test.co.uk
6@test.co.uk
7@test.co.uk

how would I return the emails that are more than one instance so e.g.

1@test.co.uk
5@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?

Cheers

Is there a reason why the Find Duplicate Query Wizard is not working for you?

Hi
Or even a total & group query asking for a count of each and setting a criteria of >1..
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)

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?

Thanks
Steph

Whenever I try to do a 'group by' and set the criteria of >1 access updates it to >'1'

Ah This should be simple! :(

Hi
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..
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)

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?

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.

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!