>Hi Cetin,
>
>Thank you so much for taking the time to revise my code and encouraging me to join UT...
>
>I took the first code that you created and my data is dead on. However, somehow my PerRej is rounding up to whole number; for example, instead of 1.58, it will show 2. Please advice.
>
>Thanks,
>Sam
Sam,
Ed's sql is more compact and does it one SQL. Check that one.
In cursor definition:
PerRej N(4,2),
change to:
b(2) or y.
If you use 2nd version or Ed's single SQL then VFP would take care of it for you.
Cetin