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

S.Clark

SELECT ID, Max(DueDate) GROUP BY ID

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