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
