Hi John,

>What I mean is, that instead of replacing "all" of the records with the (with) I only want to replace
>"one" record with the replacement value for the fields below . I was going to create an addational
>table and link it to paiddate, group code and insurance company name to handle this, but I feared
>an overall rewrite of the applacation and i'm trying to get around it.
>
>all of the fields are numbers (numaric) 8.2 and indexed
>chkamt (Check Amount) 8.2 number
>misc_amt (Misc Amount) 8.2 number
>gen_misc (Gen. Misc) 8.2 number
>

I'd STRONGLY recommend the redesign, however... You could set a flag outside of your scan loop and update only the first record, then set the flag off.