Find the First time operation happened

[Guest]

I have a query that is pulling from a LOG of operations on a trouble ticket.
I have made a table of each time an operation has happened. I want to pull a
query of all the tickets but only the first time the ASSIGN operation
happened (so I have no dupicate records) The Min only pulls the least time
that all of the operations happened therefore giving me one record. If I try
to put the ticket number in the query with the MIN formula I get an error
that TICKET# is not part of the aggregate funtion. How do I pull JUST the
minimum value for each ticket in the most efficient way?

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

The article describes 4 ways to do this.