Bill,

Thanks...yes that was a way I've done it previously...guess I was thinking there must be a more elegant way, but, oh well. Thanks again.

J

>I think that you will get the CaseAAGsID for the lowest record in the table for each CourtCasesID. (Not the CaseAAGsID for the max(date) record) You can do this with two steps.

>Not too elegant but it works!