select for last record for each customer

[zmsaadeh]

I have table with many recodrs as this table:
customerID Date Stock1 Stock2 Stock3 Stock4
112105222 22/01/2006 5 6 2 1
112105222 23/05/2006 4 8 6 7
112105222 01/02/2007 6 9 4 6
112101024 12/12/2007 7 8 9 1
112101024 15/02/2007 7 9 2 1
. .
. .
. .

by select qury I want show just the last record for each customerID as this
table

customerID Date Stock1 Stock2 Stock3 Stock4
112105222 01/02/2007 6 9 4 6
112101024 15/02/2007 7 9 2 1

Plz who is can help me in select qury

thanx

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
for 4 solutions.