Access 2010 Trying to find duplicate statements in a month
Posted on 2014-03-10
I am trying to find duplicate statements that are entered in 1 month but the data entry may be off a day.
Example: Statement Dates are 01/31/14, 02/28/14, 02/28/14, 03/30/14
or Statement Dates are 01/31/14, 02/28/14, 03/05/14, 03/30/14
I should only have 1 statement a month. I wanted to try to create a field to convert the statement date to Month format, then look for duplicates in the month.
AccountID (Account Number)
StatementDate (Statement Date)