I need to convert from local to foreign currency and vice vesa. The problem I faced was it wouldn't be accurate when converting the second time. First, I need to convert from foreign to local and store the result(in 2 dec. places) into the table. The second time I want to convert from local(from table) to foreign and display on screen, but the result will not be the same as the original value. Eg: - where exchange rate 99.9999 format 1st round - foreign $10.00 --> local $5.55 (store into table with ROUND( ) ) 2nd round - local $5.55 --> foreign $9.99 (should be $10.00 originally) Any better ways to get more accurate results? Pls advise, thanks.