On 31 Jan 2007 05:54:30 -0800, "Propoflady" <ch****@monticule.com>
wrote:
I don't know your database design, but this is a possibly equivalent
query in the Northwind sample database:
SELECT Customers.CustomerID, Customers.CompanyName, Orders.OrderID,
Orders.OrderDate
FROM Customers INNER JOIN Orders ON Customers.CustomerID =
Orders.CustomerID
WHERE (((Orders.OrderID) In (select Max(OrderID) from Orders group by
CustomerID)));
In Northwind OrderIDs increment, so in the Where clause I'm getting
the Max(OrderID) for each CustomerID.
-Tom.
>I want to do a database of horses and owners, owners change so what I
want to know how to do is in the report pull the horse and current
owner only,
All help appreciated.