How do I narrow a query to latest date connected to a field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have numerous records with dates of contact with specific vendors. I am
trying to query only the last date of contact for each vendor I have. Every
query I try returns all the records, not just the latest one.
 
Are we supposed to be able to help without understanding anything about your
table structures?
It seems that you need a basic totals/group by query but we don't have a
clue what you have tried and why it didn't work.
 

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

Combine Duplicates in Query 0
how to return record with latest date 1
DMAX in query - get record with latest date by vendor 5
Totals query and Memo field 3
Query on dates 6
need to rank in a query 4
query to pull most recent record by date 1
Date Time queries 3

Back
Top