query addition not adding right

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

made a query to add two groups of numbers both groups should be the same and
end up with 0. they do but when i try to use <>0 the record still come in.
when i put my curser in the 0 it turns to 4.44089209850063-E16. i have
opened all records to 15 decemals and have only o past the 4th decemal.
 
No idea what you are asking.

What does your query lok like?

What do you mean "add two groups and end up with zero"?
 
made a query to add two groups of numbers both groups should be the same and
end up with 0. they do but when i try to use <>0 the record still come in.
when i put my curser in the 0 it turns to 4.44089209850063-E16. i have
opened all records to 15 decemals and have only o past the 4th decemal.
Click to expand...

My head is spinning.
It would have been a good idea for you to have posted the query SQL.

Please read the new Microsoft Knowledgebase article
"How to ask a question"
at
http://support.microsoft.com/default.aspx?scid=kb;en-us;555372
 
bobs problem said:
made a query to add two groups of numbers both groups should be the same
and
end up with 0. they do but when i try to use <>0 the record still come
in.
when i put my curser in the 0 it turns to 4.44089209850063-E16. i have
opened all records to 15 decemals and have only o past the 4th decemal.
Click to expand...

4.44089209850063-E16 is close to, but not zero. So the query is acting
accordingly your instructions. Maybe consider a difference smaller than a
particular amount. e.g. ABS(value1 - value2) < 0.000001 (figure out what's a
sensible value) as a equivalent to zero instead of testing for an exact zero
value.
 
bobs said:
made a query to add two groups of numbers both groups should be the same and
end up with 0. they do but when i try to use <>0 the record still come in.
when i put my curser in the 0 it turns to 4.44089209850063-E16. i have
opened all records to 15 decemals and have only o past the 4th decemal.
Click to expand...

Sounds like you are using a FLOAT (double precision floating point
number) which is an inexact data type. Consider using an exacting data
type such as INTEGER or DECIMAL.
 
Back
Top