Max Dates Query

[Guest]

I have a query pulling for various customer numbers which needs to pull only
the data with the most recent date in a field called "service_to" field.

A poster gave the following solution to my earlier inquiry, however I do not
know sql - thus I need to know how to build it into an expression - if this
is the correct solution for my issue (multiple records for a given customer
number from which we need only the most recent date - and this for mulitple
customers in the same query).

 

[Allen Browne]

Yes, you will need to use a query to select just the most recent date from
all the records in your table.

There are 4 solutions in this article:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm