Data entered twice

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a huge database where many users enter data. Is there any
way to write a query to see if data has been entered twice by mistake?
 
If you're saying that any entry that has the same value in, say, field1,
field2, field3 and field4 is a duplicate, and you want to know about it,
create a query that includes all of those fields. Add an additional field
that you know will always have a value in it (doesn't matter if it's a
duplicate of one of the fields already in the query). Change your query into
a Totals query (you can do this through the View menu when the query's open
in Design view). That should add a new row (Total) to the grid, set to Group
By under every field. Change that Group By to Count under that extra field
you added to the query, and put > 1 as a criteria under that field.
 
Everything starts with the data in Access.

If you'll post a description of the data you have, and the table structure,
folks will be able to offer more specific suggestions about how to set up
your query.

If you are merely looking for duplications between records, you can use the
Query Wizard to find duplicates.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top