Math Does Not Add Up

[NotGood@All]

I have form that gets it info from a query. It does some math, the form has
2 text boxes that allows me to filter how long it takes to scan some
documents. The first box I enter 3 and the second I enter 4. I get the
correct data back 2 records, the first (3.4), the other (3.3) but the total
in the form footer comes to 6.0. I have checked the textbox containing the
total sum([HrsScanning]), the format is standard with 1 decimal Place, I’ve
changed it to fixed, changed the number of decimal places, I’ve even
formatted the query to standard 1 decimal place. Does anyone know what I’m
missing??

 

[John W. Vinson]

I have form that gets it info from a query. It does some math, the form has
2 text boxes that allows me to filter how long it takes to scan some
documents. The first box I enter 3 and the second I enter 4. I get the
correct data back 2 records, the first (3.4), the other (3.3) but the total
in the form footer comes to 6.0. I have checked the textbox containing the
total sum([HrsScanning]), the format is standard with 1 decimal Place, I’ve
changed it to fixed, changed the number of decimal places, I’ve even
formatted the query to standard 1 decimal place. Does anyone know what I’m
missing??

My guess is that these textboxes are bound to Number fields of the default
Long Integer datatype. An Integer is by definition a whole number, and
(regardless of formatting!) will not accept a decimal value. Check the
datatype and use Single or Decimal or Double instead.

 

[NotGood@All]

John, Hi. That is exactly what's wrong, thanks
--
NotGood@All

I have form that gets it info from a query. It does some math, the form has
2 text boxes that allows me to filter how long it takes to scan some
documents. The first box I enter 3 and the second I enter 4. I get the
correct data back 2 records, the first (3.4), the other (3.3) but the total
in the form footer comes to 6.0. I have checked the textbox containing the
total sum([HrsScanning]), the format is standard with 1 decimal Place, I’ve
changed it to fixed, changed the number of decimal places, I’ve even
formatted the query to standard 1 decimal place. Does anyone know what I’m
missing??

My guess is that these textboxes are bound to Number fields of the default
Long Integer datatype. An Integer is by definition a whole number, and
(regardless of formatting!) will not accept a decimal value. Check the
datatype and use Single or Decimal or Double instead.