>Correction.
>It rounds when I INSERT INTO the table or cursor.
>Now I used ROUND(myfield,4) but that did not work, still rounds it.
If you do an AFIELDS()n on the cursor or table, what is the size and precision of the field that is rounded? If you are trying to put a number with more precision than the field allows, it will get rounded. Modify the select statement that creates the cursor using the round() function or use place holders (e.g. 0000000.000000) as Nancy and Ed suggested.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao