[AccessD] Pull Most recent date

MS Access 2003:
==============

SELECT *
FROM tblOrders as X
WHERE (OrderDate = (SELECT Max(OrderDate) AS MostRecentDate
FROM tblOrders as Y WHERE (X.CustomerId = Y.CustomerId) ))

HTH,
Shamil

----- Original Message ----- 
From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, October 27, 2005 8:41 PM
Subject: [AccessD] Pull Most recent date


>
> I'm having a brain freeze and need some help.  I am trying write a query
> that will pull a customers orders and only show me the one that has the
> most recent order date.
>
> TIA for the help
>
> /Mike
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com