keimpe
asked on
Simple multiplication in query gives weird numbers
Dear Experts,
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??
Kind regards,
Keimpe
* screenshot is from an Access query in a database containing linked SQL tables. However, an SQL View gives the same results.
Weird.png
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??
Kind regards,
Keimpe
* screenshot is from an Access query in a database containing linked SQL tables. However, an SQL View gives the same results.
Weird.png
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER