how to display the last order date

[JRCharlie]

Hi all I have a customer table with an address Column and an Order table with a OrderDate column .
I would like to create a Query that would display the customer address and only the Last order made.
So far I was only able to display the address and and all the Order dates

[AlexHedley]

Use SELECT TOP 1 from the Orders Table then join the Customers to that.

[JRCharlie]

Thanks Alex for your reply.
I have tried it many ways but can't come up with the right query.
This is one of my tries, it returns one date and one customer only, and this date is not the earliest . Could you help me with it.

SELECT TOP 1 Orders.OrderDate, Customer_Tbl.ID
FROM Customer_Tbl RIGHT JOIN Orders ON Customer_Tbl.ID = Orders.CustomerID;

[AlexHedley]

You would need to order the query to get the last one or an example

SELECT ID, MAX(DATE)
FROM [table]
GROUP BY ID

[June7]

If you want to retrieve all related data, not just the ID and Max Date, a subquery is one method:

http://allenbrowne.com/subquery-01.html#TopN

Another is DMax domain aggregate function:

SELECT * FROM Orders WHERE [OrderDate]=DMax("[OrderDate]", "Orders", "ID=" & [ID]);

[JRCharlie]

Thanks You Both for your replies I have it working