[haychj]

I have an Access 2003 table (Table1) with four fields:
Amount (number, single format, 3 decimal places)
Add (number, single format, 3 decimal places)
Calc (number, single format, 3 decimal places)
Test (number, single format, 3 decimal places)

There is one record:
Amount=40
Add=1.021
Calc=40.84
Test=

The first query updates the "Test" field by [Amount]*[Add] with the result that the test field now contains the value 40.84

Then I run a query to find records where [Test]<>[Calc] and it returns the record even though the values in the two fields are equal.

Help! Please???

[zhouma]

What does the record say when you run the 2nd query?

When I run the second query, I get a 0 for the first record (using the info you listed). I added in a few records of my own and got -1. If I'm not mistaken the 0 means False/No and the -1 means True/Yes. So the 0 means that no records match [Test]<>[Calc] and the -1 means that records match [Test]<>[Calc].

Either way please explain more so I can get a better handle on what you are looking for.

Best,
Zhouma

[OBP]

haychj, welcome to the forum.
When I do the test query using [Test]<>[Calc] I do not get any records. If I change to [Test]=[Calc] I get the one record returned.
See the attached database.

[haychj]

The value I get in the test field is 40.4799995422...! I may have found the answer. When I change the number format to Double with the dacimals as Auto I get the correct result. Thanks!