>Name Allowance Rate/Trip Services Rate Sharing
>CKW Meal 15.00 ServiceA 10:90
>CKW ServiceB 10:90
>CKW Transportation 20.00 ServiceA 20:80
>CKW ServiceB 20:80
>
>>Name Allowance Rate/Trip Services Rate Sharing
>CKW Meal 15.00 ServiceA 10:90
>CKW Transportation 20.00 ServiceB 20:80
>
>select Name, Allowance, Rate, Services, RateSharing; from MyTable; order by ...; group by Allowance; into cursor TempReport report form...This should eliminate the duplicate records. A more or less arbitrary record will be chosen from each group, so you must be sure that fields like "Rate Sharing" have the same values for each record in a group.