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

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER