Selecting duplicates with a button

[#1]

I have a list of accounts that appear on an unavailable report every month.   These accounts are differentiated by a unique Account_Id.

If an account is listed on a report in consecutive months then there will be multiple instances in the database with only the Report_Date being different between each row.

for example:

Account_Id           Report_Date          Reason

111                         6/1/2013               No Access

111                         5/1/2013               No Access

112                         5/1/2013               No Access

I need to be able to select the number of accounts with variable numbers of duplicates.   So a button for anything with 2 duplicates, a button for 3 duplicates, etc.  I have already created a table that shows the number of duplicate occurences per account.   Just want a single button to make a selection.

The only field that will change is the Report_Date so I was attempting to do a Select in Field using Account_ID and the following count function in Search string but with no luck.

='=count(Report_Date)>5

I am pretty sure this is not a difficult issue and am just missing something.

I am also open to any ideas on how to modify the load to count duplicate instances of an Account_Id so that it can be used as a variable for selection purposes.

Thanks

[#2]

Hi,

Look at the attachment. Maybe can help.

Rebeca