D
Des
Hi,
Acces97 just pulled a trick I hadn't found before. Doing
currency calcs for invoices, the final values (currency
data type) are displayed as currency in text boxes, the
CALCULATED values are all correct, BUT the DISPLAYED
values are being screwed. Access is applying a round down
on any fractional (penny) value if the the total displayed
is less than £100 and rounding up if the total is above
£100. Useless for invoices where totals have to reconcile.
Any solutions or workarounds known or available?
Thanks
Des
Acces97 just pulled a trick I hadn't found before. Doing
currency calcs for invoices, the final values (currency
data type) are displayed as currency in text boxes, the
CALCULATED values are all correct, BUT the DISPLAYED
values are being screwed. Access is applying a round down
on any fractional (penny) value if the the total displayed
is less than £100 and rounding up if the total is above
£100. Useless for invoices where totals have to reconcile.
Any solutions or workarounds known or available?
Thanks
Des