Percent Format

  • Thread starter Lirva Smith via AccessMonster.com
  • Start date
L

Lirva Smith via AccessMonster.com

When I enter 25% in my query it displays as 2500%, what can I do to have it
display as 25%?

My field size is: Single
Format: Percent

Thank you!
 
L

Lirva Smith via AccessMonster.com

The total is not correct though.

$100 – 25% is now displaying $99.75

Is there something I should do different in the total field. This is what I
have:

Total: [TotalBFDiscount]-[Discount]
 
R

Ricky Hicks Access MVP

I think I answered this question by you in another forum ....
It would be the Total minus the Total mutilplied by the Discount percentage
....

RDH
 
Top