Access 2010 Query to locate most recent item only, when 1 is expected each month
Posted on 2014-01-02
I receive statements each month and I am trying to determine if a statement did not come in. Example: account 12345 last statement was November 2013, so I am missing a December statement.
I am trying to locate the newest statement received only but my query gives me all of the statement dates, not just the newest.