Selecting Duplicate Date Records in a Group

[Former Member]

I have a report that looks like this

                    patient name                Program name          Date of service

Primary Care (group 1)

     Dr. John Smith (group 2)

             Jane Doe (group 3)

                    Jane Doe                    primary care                    1/1/15

                    Jane Doe                    primary care                    1/2/15

                    Jane Doe                    primary care                    1/2/15

           Jack Black

                    Jack Black                  primary care                    1/2/15    

                    Jack Black                  primary care                    1/17/15

I want a way to select records in patient group (group 3) where the patient had more than one service in a day. So in my limited example the only records I want to show are

Primary Care (group 1)

     Dr.. John Smith (group 2)

          Jane Doe (group 3)

                   Jane Doe                    primary care                    1/2/15

                   Jane Doe                    primary care                    1/2/15

I have been able to use a running total to calculate the number of distinct dates per group, but I need a way to select repeat dates per group. Thanks for the help.

[former_member226669 · Accepted solution]

Hi Nate,

You can create a group Group 4 on the Date field.

Add the below code to Select Expert... -> Group:

Count ( {database field used for the name}, {Group 4 field})  > 1

- Nrupal