Those stars generally represent numerical overflow. i.e. you tried to cram 5 digits into a N(4) field, or something of the sort. I would recommend adjusting the size of the field where the result winds up to avoid this situation. Not sure how to browse for it, though.
>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
Paul A. Busbey
Victoria Insurance