Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    percent increase (Access 2000)

    I want to show a control on a report increased with 5 %. Which is the correct way ? I have written the following expression :
    Me!dummy = Me!EndPrice + Me!EndPrice * 5 / 100
    I get a false figure,even though i format the control to a percentage

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: percent increase (Access 2000)

    There are a few ways to write the formula, but what you have written looks correct.

    But if you are increasing a price by 5%, the result should be currency not percent. So don't format the control as a percent.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: percent increase (Access 2000)

    yes,of course ! it shoulld be currency ! Thank you !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •