P
Pam Ammond Pierce
I am off a cent on some report lines. When I try to fix it (using int or fix
functions) I am off much larger amounts.
I am trying to subtract the commission from the payment owed:
Payment - txtCommission = Amount Still Owed
Examples:
Payment txtCommission Amount Still Owed
$32.18 $32.18 ($0.01) WRONG
$170.50 $170.50 $0.00 CORRECT
txtCommission control source is a report textbox named TotalAmount, times
5%
=[TotalAmount]*0.05
Payment control source is a field in the report source query
InvoiceCreditAmt
Amount Still Owed control source is:
=[txtCommission]-[InvoiceCreditAmt]
These 3 report textboxes have Format set to Currency and Decimal Places set
to 2.
The 2 amount fields in the database use DataType: Number, Field Size:
Single, Format: Currency
Can anyone tell me the correct source for these textboxes so none of them
have rounding errors? I would think since I'm using currency that this would
work.
Thanks in advance!
Pam
functions) I am off much larger amounts.
I am trying to subtract the commission from the payment owed:
Payment - txtCommission = Amount Still Owed
Examples:
Payment txtCommission Amount Still Owed
$32.18 $32.18 ($0.01) WRONG
$170.50 $170.50 $0.00 CORRECT
txtCommission control source is a report textbox named TotalAmount, times
5%
=[TotalAmount]*0.05
Payment control source is a field in the report source query
InvoiceCreditAmt
Amount Still Owed control source is:
=[txtCommission]-[InvoiceCreditAmt]
These 3 report textboxes have Format set to Currency and Decimal Places set
to 2.
The 2 amount fields in the database use DataType: Number, Field Size:
Single, Format: Currency
Can anyone tell me the correct source for these textboxes so none of them
have rounding errors? I would think since I'm using currency that this would
work.
Thanks in advance!
Pam