I'm using access 2002, all updates applied.
the problem i'm having is with a footer level textbox on a report rounding values. the control source is =Sum([RawMinutes]) RawMinutes is a Double data type with 3 decimals. the data displays fine in the detail section, but is rounded up in the footer.
for example, here are 4 values: 5, 3, 3.267, 2.467
totaling (in un-rounded reality)13.734. what shows in the report is 14. where the problem lies is that this number is later summed and (potentially) rounded again.
does anyone know how to stop this rounding?
the problem i'm having is with a footer level textbox on a report rounding values. the control source is =Sum([RawMinutes]) RawMinutes is a Double data type with 3 decimals. the data displays fine in the detail section, but is rounded up in the footer.
for example, here are 4 values: 5, 3, 3.267, 2.467
totaling (in un-rounded reality)13.734. what shows in the report is 14. where the problem lies is that this number is later summed and (potentially) rounded again.
does anyone know how to stop this rounding?