Greetings--

I have a table where where I have a date field where I would like to find a max or min value based on the value of another field. This table is dynamic (will be changing) so I would like to, say, find all rows with the value "IT" in one field and then find the min or max date in the other field. This table would not be sorted so that all "IT"s would be together, and it is possible that the number of IT rows might change.

Is this possible?

Thanks!