query to return last record from groups

[Seth C]

Your help is appreciated.

I have records that are arranged by step number of a procedure
a.
b.
c.
etc.

Each step has multiple rows of data points listed by the time they were performed.

a 1
a 2
a 3
b 4
b 5
b 6
c 7
c 8
c 9
etc

I am trying to create a query to retreive the latest time for each step that was performed (a3, b6, c9...)

 

[Fuga]

This might be what you´re looking for:

http://www.access-programmers.co.uk/forums/showthread.php?threadid=34256&highlight=top+group

Fuga.