Percent issues in 2007

[MuzicK622]

We just converted to Office 2007, so that could be my issue. Here is
my problem:

I have a field called "Percent Discount" with a field size set to
Single and no decimal places. On theform, the user types in 10% into
the field (2007 automatically enters the % sign). The next field is an
expression =[Amount]-[Dollar Discount]-[Percent Discount] (The user
can give a dollar discount or a percent discount depending on their
needs). It is only subtracting 1% rather than 10%. How do I get it to
both show 10% for the user and subtract the 10% from the amount?

 

[MuzicK622]

We just converted to Office 2007, so that could be my issue. Here is
my problem:

I have a field called "Percent Discount" with a field size set to
Single and no decimal places. On theform, the user types in 10% into
the field (2007 automatically enters the % sign). The next field is an
expression =[Amount]-[Dollar Discount]-[Percent Discount] (The user
can give a dollar discount or a percent discount depending on their
needs). It is only subtracting 1% rather than 10%. How do I get it to
both show 10% for the user and subtract the 10% from the amount?

Sorry, it's subtracting .10 percent now. (I right-clicked and selected
Equal to 10% from the menu)

 

[Evi]

Would it be easier if you let the user type in eg 10 rather than 10% and
have the expression divide that entry by 100 to make 10% ?
Evi

We just converted to Office 2007, so that could be my issue. Here is
my problem:

I have a field called "Percent Discount" with a field size set to
Single and no decimal places. On theform, the user types in 10% into
the field (2007 automatically enters the % sign). The next field is an
expression =[Amount]-[Dollar Discount]-[Percent Discount] (The user
can give a dollar discount or a percent discount depending on their
needs). It is only subtracting 1% rather than 10%. How do I get it to
both show 10% for the user and subtract the 10% from the amount?

Sorry, it's subtracting .10 percent now. (I right-clicked and selected
Equal to 10% from the menu)