Last order made by customer from a table

[Alok K Gupta]

I have 500 customers and 50 type of products with 20 colours each and 5 to 6 type of designs for each product. I want to retrieve data for each customer last order details. Fields in table are
C_Name P_Name Colour Designs Order date

[Seth Schrock]

The following query will get the last order by customer. If the field Order date is just a date field and the customer makes two orders on the same day, both orders will be included.

SELECT Lst.C_Name
	, Table_Name.P_Name
	, Table_Name.Colour
	, Table_Name.Designs
	, Lst.[Order date]
FROM
	(SELECT C_Name, Max([Order date]) As LastOrder
	FROM Table_Name
	GROUP BY C_Name) As Lst INNER JOIN Table_Name
	ON Lst.C_Name = Table_Name.C_Name 
		And Lst.LastOrder = Table_Name.[Order date]