Query to get the last record

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

Guest

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
In a query, show master records even if a child record doesn't exi 2
Find last record in date field for each device in the device field 5
Query for 1st field, if blank then query 2nd field but not both. 6
Update Query and record lock violations 6
Combine Duplicates in Query 0
Last record search not working 3
Delete query 4

Top