Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiply Value by a percentage (Access 2000)

    I cannot get a value of type double to be multiplied by a percentage. Ideas?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiply Value by a percentage (Access 2000)

    Your question is rather vague. How have you tried to do it, and what went wrong?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiply Value by a percentage (Access 2000)

    I just have two text boxes, one with a value of type double and is a currentcy value and the other is a percentage value., Eg (200 - 2% ), I always get a type mismatch. The problem is that I cannot change the percentage value to type double for some reason.

    Basically I keep getting a type mismatch error is my code

  4. #4
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiply Value by a percentage (Access 2000)

    Actually I got it now. I never had my textbox format as currency. <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22> I thought it was odd I could not divide by percentage

Posting Permissions

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