query with onefield Unique value and last date/time

[dwe73]

I need to build a Status Query from my DB that shows the record for each unique value in Field 1 with the most recent date/time entry? Say my DB looks like....

Record ID AutoNumber
Field 1 Combo Box Text (4 choices)
Day Short date


Time Short Time
Field 2 Text
Field 3 Short Time
Field 4 Text

These entries may be several times a day for each of the 4 choices! I need the Query to return the last sequential Entry for each of the 4 choices of Field 1.

Thanks in advance for all of your responses!

[alansidman]

Try this:

SELECT Table1.Field1, Max(Table1.Day) AS MaxOfDay, Max(Table1.Time) AS MaxOfTime, Table1.Field2, Table1.Field4
FROM Table1
GROUP BY Table1.Field1, Table1.Field2, Table1.Field4;

[pbaldy]

Or this if I understand correctly:

http://www.baldyweb.com/LastValue.htm