I'm using Access 2010 and I have a table [see below] ... What I need is a query that will give me back the acct. no & the most current(or max) date for that account.
For Example I would need the query to come back with acct No. 1 & 6/25/2012 since thats the most current date.
I've tried Dlookup and max functions in access but since you can't have aggregate functions in criteria i'm at a loss and currently doing this ->
acct No Load Date 1 5/1/2012 1 5/25/2012 1 6/25/2012 2 5/2/2012 2 5/25/2012 2 6/6/2012 4 5/2/2012 4 6/6/2012 5 5/26/2012 5 6/2/2012 5 6/7/2012 25 6/26/2012 33 5/1/2012 33 5/25/2012 54 5/31/2012 62 6/25/2012 62 7/1/2012 98 7/5/2012 98 7/24/2012