Hi Benn,
>I have a SQL-Server 6.5 table with a numeric field (10,2). When I enter a value that ends with xxx.35 in my View and run Requery("View") the value changes to xxx.34. No other decimal values change value. ????
Does this only happen with xxx.35? Are you doing any sort of calculations on this data that could cause a rounding issue? On that same topic, why not try to store the value with REPLACE field WITH ROUND(memvar,2)? Maybe there is an internal rounding issue that this may resolve.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05