>I am wondering how I can get the record for a certain MemberID; there are several records of termination for this one person, and they are valid because the person had insurance coverage at various points in time and eventually allowed his coverage to Terminate for one reason or another. I have to fin the record having the MAXIMUM Termination_Date.
>
>I tried using the MAX(Term_Date) function in the HAVING clause but it doesn't have enough arguments, and doesn't seem to apply there.
>
>It seems that MAX in FoxPro and T-SQL are a bit different.
how about something like:
select top 1 coverages.pk,coverages.member_id from coverages order by member_id asc, expdate desc
Brandon Harker
Sebae Data Solutions