[AccessD] Pull Most recent date

Thank you very much Shamil, I knew it wouldn't be hard 

-----Original Message-----
From: Shamil Salakhetdinov [mailto:shamil at users.mns.ru] 
Sent: Thursday, October 27, 2005 11:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com