G
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?
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?