Percent issues in 2007

  • Thread starter Thread starter MuzicK622
  • Start date Start date
M

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?
 
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?
Click to expand...

Sorry, it's subtracting .10 percent now. (I right-clicked and selected
Equal to 10% from the menu)
 
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?
Click to expand...

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