Querie to Find Maximum Value

[thecuteonexoxo]

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

[jzwp11]

You will need an aggregate query that groups by acct no

SELECT [Acct No], Max([Load Date]) as MostRecentLoad
FROM yourtablename
GROUP BY [Acct No]

[thecuteonexoxo]

Works perfectly. Thank you so much!

[jzwp11]

You're welcome.