Max Dates Query

B

Bryan Brassell

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Easy one I thought.... 10
Max Date in a query whilst showing all fields 5
Query maximum values 2
How to return Max date or Null (if there is a Null present) 4
can't find the right query 0
Query to select values after a certain date 0
Select Max and Next to Max Dates 2
In a query, show master records even if a child record doesn't exi 2

Top