Can I find the last record entered in a "group" of records

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

Guest

I have a multi-group of records and would like to find the "last" entered in
each group based on a date.
 
Try something like

SELECT [M1].*
FROM [TableName] AS M1
WHERE M1.[DateFieldName] In (SELECT Top 1 M2.[DateFieldName]
FROM [TableName] as M2
WHERE M2.[group] =M1.[group]
ORDER BY M2.[DateFieldName] Desc)
 
You must log in or register to reply here.

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

Access query for last date entered 4
Autolookup Query to find Multiple Records 3
How to count consecutive records base on 2 groupings 0
How do I find the last record ? 5
Access Dcount function in access 0
Find last record in date field for each device in the device field 5
Query to group similar number combinations? 4
Random Function for Selecting Records 3

Back
Top