Find Duplicates (multiple criteria)

  • Thread starter Thread starter Jeff F via AccessMonster.com
  • Start date Start date
J

Jeff F via AccessMonster.com

I have a table that contains claims data. I need to isolate duplicate claims.
The combination of three fields (name, date and procedure) all of which must
be identical constitute a duplicate claim. Any suggestions on how I would do
this? Im a code novice and use query design or sql only. Any assistance
would be greatly appreciated.

Thanks in advance for your time.

Jeff
 
You can create a field called "Duplicate Key" within your table and use
Update query to combine those three fields in the Duplicate Key field. In
addition, you can use Datevalue() for date field to convert it into a number.

I hope that'd help.
 
Build a TOTALs query with the three fields. Then add one of the three fields
again but make sure that field will not have any nulls.
In the design view grid change the Total: row from Group By to Count.
Set criteria to >1 to find duplicates
 
Back
Top