Oh, I know that now. That assumes I know where I have to make the change. I didn't know which field had the problem, nor where it occurred. So, I needed to browse the file (10,000 records or so) to find where the problem was.
>Update! Ignore!
>
>Since you use VFP9, I suggest you try using CAST
>calc cast(sum(field1 / field2) as n(20,5) to lnTotal in otherCursor
>
>>I've just learned it's possible to get stars (****) in a numeric field. I did something like
calc sum(field1 / field2) to lnTotal in otherCursor
>>Select MainCursor
>>Replace Total with lnTotal
>>... and where there are no records in otherCursor, lnTotal gets a lot of stars, and then so does the field
.
>>
>>My question: how can I find the records in MainCursor that have stars (instead of numbers) in field Total? Browse for ???????
>>
>>Thanks
Jim Nelson
Newbury Park, CA