Int in a summed field

[tcheck]

I have been working on crashing 2 querys together and I fond that the sum of one of the fields are differnent even though if I use the functions of round or INT they shoudl be the same. Then I found the below problem, any help would be appreciated.



I have a query that has a field that is a Single, Currency in the Access table. When I run a query with the INT function of;

TotalComm: Sum(Int([compute])) I get 169

When I run a round function of;
TotalComm2: Round(1*[compute],2) 170.76

Here are the totals;
SumOfcompute3.7200000295.579999924161.4600067

Why would the INT round it down to 169?

[pbaldy]

Not sure why they would be the same. Int() will truncate the decimal portion off each value, round will round it to 2 digits. That decimal portion will cause the Round() function to return a higher value. Your sample data didn't come through right.

[tcheck]

What I am attempting to do is link 2 sums together from 2 different tables that have slightly differnent amounts.

1st table has three differnt sets
5.57999992370605
3.72000002861023
161.460006713867
For a total of 170.76
When I ran the expression of
TotalComm: Int(Sum([compute_0012])) I received a total of 169 not 170.
If I ran TotalComm: Int(Sum(Round(1*[compute_0012],2))) I get 170

The other table just has 170

I have no idea why.

[pbaldy]

I would expect Int(Sum(...)) to return the same value, and it does in my test. Sum(Int(...)) returns 169, again as I would expect, because the truncation would happen before the summing.

[tcheck]

I got it to work.