B
Bongard
I am having some rounding issues with one of my queries. I have two
tables for which I am comparing interest rates. For now we'll just
call them table1.IntRate1 and Table2.IntRate2. The field types are
currency and limited to two decimals and I have checked the source
system to make sure they don't include any characters after the
hundreths digit and they are clean. I am trying to create a formula
field in my query that is "Diff:round([table1.IntRate1] -
[Table2.IntRate2]),0) However even when IntRate1=7 and IntRate2 = 6.5
the query is rounding this down to 0 instead of rounding .5 up to
1.... Does anyone have any ideas on why this might be and how I can
around this?
Thanks and much appreciated,
Brian
tables for which I am comparing interest rates. For now we'll just
call them table1.IntRate1 and Table2.IntRate2. The field types are
currency and limited to two decimals and I have checked the source
system to make sure they don't include any characters after the
hundreths digit and they are clean. I am trying to create a formula
field in my query that is "Diff:round([table1.IntRate1] -
[Table2.IntRate2]),0) However even when IntRate1=7 and IntRate2 = 6.5
the query is rounding this down to 0 instead of rounding .5 up to
1.... Does anyone have any ideas on why this might be and how I can
around this?
Thanks and much appreciated,
Brian