I hope someone can help.
I have a table with among other the following fields: Customer_ID and Customer.
I have a second table with among other these associated fields: Customer_ID and Ordered_Date.
So this second table may have the following entries:
Customer_ID and Ordered_Date
112 12/03/2011
112 17/05/2019
213 23/01/2013
213 01/04/2021
I would like to construct a query that shows the most recent Ordered_Date per Customer_ID, that is, only one Ordered_Date per customer, and the most recent date for that customer.
Any help please?!
I have a table with among other the following fields: Customer_ID and Customer.
I have a second table with among other these associated fields: Customer_ID and Ordered_Date.
So this second table may have the following entries:
Customer_ID and Ordered_Date
112 12/03/2011
112 17/05/2019
213 23/01/2013
213 01/04/2021
I would like to construct a query that shows the most recent Ordered_Date per Customer_ID, that is, only one Ordered_Date per customer, and the most recent date for that customer.
Any help please?!