Duplicates- (and not well versed with Access)

[m gwyn]

in medical record data-
I'm pulling lists of patients (150) by a particular date of service, they have a key of a billing #, and a batch #. and three different document types
I want to create something that will show me duplicate billing numbers that also have the same batch number, and doc type.
And then be able to use this creation over and over for each date of service
Again-
I'm trying to create a tool that will allow me to quickly pull a list of all the documents scanned/indexed into patients charts on a particular visit date, and to find a document type, w/ the same billing number, that may have been entered twice in the same batch.

If the same document type, with the same billing number, appears in the same batch - a mistake has been made and I need to correct it.

 

[Joe4]

Create query from your table, adding the following fields to the query:

billing numbers
batch number
doc type

Then add the "doc type" field a second time.

Now click on the "Totals" button (looks like a Sigma). This will add the phrase "Group By" under each field in the query. Under the last "doc type" field, change the "Group by" to "Count" and then put ">1" in the Criteria of this field (without the quotes).

Now if you view the query, it will return all instances where there are duplicate records based on those three fields, and the last column will tell you how many duplicates there are.

This query can be re-used over and over without making any changes to it.