Exponential values

[Guest]

Hi All,

I have a query that takes all of the transactions for suppliers for a period
and sums the total values of each transaction to effectively report a balance
for each supplier.

This works fine for most transactions, however when invoices and credits or
payments are for values such as 1.312, where the balance should be zero as
displayed on the account of that supplier, the query reports values such as
1.3122211 etc.

How do I get the query to ignore these types of numbers or make them zero?

 

[Larry Daugherty]

Convert results to integers. Where you know that a value greater than
zero should really be zero, you'll have to supply the smarts.

HTH

 

[John W. Vinson]

This works fine for most transactions, however when invoices and credits or
payments are for values such as 1.312, where the balance should be zero as
displayed on the account of that supplier, the query reports values such as
1.3122211 etc.

How do I get the query to ignore these types of numbers or make them zero?

Change the datatype of the field from Double or Float - which has roundoff
error - to Currency, which has four and exactly four decimals and NO roundoff
error.

You can also use the Round() function in query calculations.

John W. Vinson [MVP]

 

[Guest]

Many thanks to you both.
--
K Hogwood-Thompson

Change the datatype of the field from Double or Float - which has roundoff
error - to Currency, which has four and exactly four decimals and NO roundoff
error.

You can also use the Round() function in query calculations.

John W. Vinson [MVP]