Another thing that is not working correctly for me is the use of the Percentage format for a number. I have a field on a form Commission where the criteria are:

Field Name: Commission

Format: Percentage

Row Source: "0";".15";".10"

Row Source Type: Value List

Format: Percent

Decimal Places: 2

The form has a combo box that permits the user to select one of these three values.

A calculation is made on a query where the total is:

Code:

TotalCost: NetRate*(1-[Commission])

If the commission is zero, then the calculation results in a number with two decimal places. This is what I want. But if the commission is .10 or .15 then the calculation results in a number with that has 12 decimal places. This is crazy! For example, one calculation has a [NetRate] of $100 and a [Commission] of 10%. The calculation results in 89.9999998509884.

I have performed the same calculation with NetRate*.9 and it comes out $90. But when I calculate the multiplier 1-Commission I get 0.899999998509884. So I know it has to be with the setting of the Row Source, but it looks OK to me.

What is going on? I know I can round and correct this, but why would this result occur?