Find the Last Date in a Table using a Query

[papic1972]

Hi All,

I have a table "tblOrderInput" that has the following fields:

OrderID Customer OrderEntryDate
(E.g. data as follows)
12000 Joe Blow 12/10/03
12001 Mr Smart 12/09/04
12002 Joe Blow 10/10/04
12003 Mrs Smith 11/10/04
etc.........

How do I create a query that returns the customer name & the last Order Entry Date?

Thanks in advance.

 

[PHV]

Something like this ?
SELECT Customer, Max(OrderEntryDate) As LastOrderEntryDate
FROM tblOrderInput
GROUP BY Customer;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[papic1972]

Hi PHV,

That worked a dream!!!!!!!!!!!!!!!!


THANKS!!!!!!!!