Query for last date of purchase order (1 Viewer)

Harris@Z

Registered User.
Local time
Tomorrow, 00:08
Joined
Oct 28, 2019
Messages
29
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?!
 

Gasman

Enthusiastic Amateur
Local time
Today, 22:08
Joined
Sep 21, 2011
Messages
9,297
Use a Totals query and Max() on the date field
 

Harris@Z

Registered User.
Local time
Tomorrow, 00:08
Joined
Oct 28, 2019
Messages
29
Thank you. I am not sure how one would do this (I am not an programming expert!)
 

Harris@Z

Registered User.
Local time
Tomorrow, 00:08
Joined
Oct 28, 2019
Messages
29
I think I have worked it out! Thanks, let me check the results
 

Users who are viewing this thread

Top Bottom