Query to get the last record

  • Thread starter Thread starter DaranVector
  • Start date Start date
D

DaranVector

I have two tables, one master Info and one with multiple records for
each record in the master link by ID field. I have a field call Due
Date in the secondary table. I am trying to create a query that
returns only the last due date for each ID.
I have tried to create a Select query using the Max function in the
Totals section of due date and it is not working. It still gives me
all the records in the secondary table.
 
SELECT ID, Max(DueDate) GROUP BY ID

My guess is you're grouping by both fields. Group by only the ID.
 

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

Another most-recent date query 0
Query for 1st field, if blank then query 2nd field but not both. 6
In a query, show master records even if a child record doesn't exi 2
Joining 3 Queries That Count 8
Combine Duplicates in Query 0
Filtering records by date 2
Problem querying table linked ODBC Database 2
Find last record in date field for each device in the device field 5

Back
Top