Group By query

[Guest]

I have a table as shown below

TABLE NAME:BAL

Account Date Balances
OTC 01-Jan-07 1000
OTC 02-Jan-07 6000
OTC 03-Jan-07 3000
OTC 04-Jan-07 4000
OTC 05-Jan-07 5000
ICT 01-Feb-07 2500
ICT 02-Feb-07 3000

I want to extract the row which has the latest date with corresponding
balance from table BAL

Result expected is as shown below

Account Date Balances
OTC 05-Jan-07 5000
ICT 02-Feb-07 3000

 

[Joan Wild]

See http://www.mvps.org/access/queries/qry0020.htm