at the moment my simple database has ID-Company-Country
ID is primary
All I want to do is find out the Company duplicates including how many there are.

I used to just run the duplicate query wizard, but for some reason it keeps coming up with all the companys?? Any Ideas>?

If you have all of these fields in the same table, why not just use the filter by selection option? I don't know if that's the case, but your post did not specify how many tables were involved?

I/m only working with one table, but have found out that the problem was related to having a field in "memo" rather than text. Simple solution, I wish there was a simple solution page somewhere