Most recent date function

[Techknownothing]

I have a main form that populates tblCUSTOMER with many different
customers.
That form has a subform that populates tblHISTORY tracking the
purchases of each individual customer by date. Both tables are linked
by AUTO ID.
I want to run a query that pulls only the most recent entry from
tblHISTORY for a particular set of customers.
Any assistance is much appreciated

JC

 

[pietlinden]

create a totals query, Group by CustomerID, MAX(SaleDate).

 

[Guest]

I would start with a Totals query on tblHISTORY using only the CustomerID
field and the date field that will contain the most recent date. In the
Totals row of the query, use Group By for the CustomerID and Max for the date.
Then create another query that has tblCustomer joined to the CustomerID in
the above query and tblHistory joined to tblCustomer.