D
Debbie
Hello everyone,
I have spent HOURS on this so maybe someone could help. I have a table with
the field AmountEarned and it is defined as:
Datatype = Currency
Decimal = 2
Format = Currency
I have a program that calculates the AmountEarned. The equation is:
AmountEarned = (TotalSales - TotalCost) * CommRate
Total Sales and TotalCost are defined exactly as AmountEarned
CommRate is a decimal (Example - .01)
In my program, the calculation yields the number 20.196 and that is what's
being stored in the table. I want 20.19 to be stored in the table. I used
the Format property to display 2 digits past the decimal but in doing that,
it rounds it to 20.20 and then if you click in the AmountEarned table, it
actually shows 20.196. The problem with using the Format property is it
rounds up and I don't want that. I have tried everything I can think of.
Does anyone have any ideas as to what I'm doing wrong? Thanks so much.
Debbie
I have spent HOURS on this so maybe someone could help. I have a table with
the field AmountEarned and it is defined as:
Datatype = Currency
Decimal = 2
Format = Currency
I have a program that calculates the AmountEarned. The equation is:
AmountEarned = (TotalSales - TotalCost) * CommRate
Total Sales and TotalCost are defined exactly as AmountEarned
CommRate is a decimal (Example - .01)
In my program, the calculation yields the number 20.196 and that is what's
being stored in the table. I want 20.19 to be stored in the table. I used
the Format property to display 2 digits past the decimal but in doing that,
it rounds it to 20.20 and then if you click in the AmountEarned table, it
actually shows 20.196. The problem with using the Format property is it
rounds up and I don't want that. I have tried everything I can think of.
Does anyone have any ideas as to what I'm doing wrong? Thanks so much.
Debbie