Full post title: Identifying the record with the highest value in one field among all the records in a group that have certain values in another field

I am grouping by the field "job"; within each group, I want to identify the record that has the highest value in the "operation.sequence" field among all the records in that group that have one of several values in the "operation_service" field.

I am going to use this formula to suppress all the records within each group that have a value in the "operation.sequence" field that is greater than the value identified by the formula.

Any ideas? Thanks!

Unfortunately, this forum does not allow me to insert screen shots. Please look at my posting on another forum: <http://www.forumtopics.com/busobj/viewtopic.php?p=960303#960303>

Thanks!

Matteo