I have an SQL 2005 table that contains two fields of datatype INT and one field of datatype REAL. They contain normal numbers. When I multiply all three and the REAL field contains a simple fracion, I get the results you see in the attached image*
Why is this??
* screenshot is from an Access query in a database containing linked SQL tables. However, an SQL View gives the same results.