Finding dulicate entries

[mikeymay]

I have a database that I suspect has some duplicate entries in it.

Rather than using the query avaiable in Access (which only seems to look for duplicate entries in a field) is there something I could use that would look for duplicate entries on all fields used in a record?


Thanks

 

[KenHigg]

How many fields are in the suspect table?

 

[mikeymay]

I only want to check 4 of the 8 fields in the table.

 

[KenHigg]

As an info only type drill you could simply do a quick totals query and qroup on these fileds and then do a count column...

 

[mikeymay]

Ok, I have managed to run a query that concatenates the 4 fields together but when using design view it doesn't seem to like me using the count function in next column.

 

[Brianwarnock]

The find duplicates wizard will allow more than 1 field.
Originally you said all fields!!

Brian

 

[mikeymay]

Sorry, I quickly put the initial thread together.

I have a table with 8 field of which I want to use 4 of them to check for duplicates.

These four fields, when put together, should form a unique string that I would like to check.

 

[KenHigg]

Pull down all four fields and do a totals and group on all four. Then bring down the fourth field again and instead of doing a group do a count on it. Then to take it one step further put a limit on this field to only show records where the value is greater than 1.

 

[mikeymay]

Great stuff!!!

 

[Brianwarnock]

Pull down all four fields and do a totals and group on all four. Then bring down the fourth field again and instead of doing a group do a count on it. Then to take it one step further put a limit on this field to only show records where the value is greater than 1.

I think that is what the find dups query wizard does, why reinvent the wheel?

Brian

 

[gemma-the-husky]

brian, i rarely use the find dups wizard - i find its much easier to do it directly

 

[Brianwarnock]

brian, i rarely use the find dups wizard - i find its much easier to do it directly

Yes but you know how to do it, the poster didn't, so start with the wizard and learn by examining what it does. it is also simpler to say use the wizard than try to explain when you do not have all the details.

Brian

This also seems to contradict your argument in the thread about using SQL as first choice over the Design grid.

 

[KenHigg]

Great stuff!!!

Glad you got it working -

 

[gemma-the-husky]

This also seems to contradict your argument in the thread about using SQL as first choice over the Design grid.

did you mean me? I didn't say anything about SQL

i use the query design grid to create unmatched queries, rather than the wizard is all.