Duplicates- (and not well versed with Access)

m gwyn

New Member
Joined
Jan 21, 2005
Messages
13
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.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,910
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,361
Messages
5,635,808
Members
416,884
Latest member
leeshjay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top