Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    16

    Unanswered: Help with Percentage

    Hi, I have a small db which has my price list, I have 3 fields in it,

    1) Item #
    2) Item Description
    3) Item Price

    I want to add a 4th field which is

    4) Discount Price

    So when I enter the Item Price as $100, then the Discount Price should automatically show $75 (as a 25% discount). Can anyone help me with it?

    Thanks for your help in advance.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Perhaps have the onchange property for the field call a JavaScript function which changes the appropriate field perhaps something like this:

    function UpdateTheDiscountPrice() {
    document.frmMyForm.MyDiscountPrice.value = document.frmMyForm.MyItemPrice.value * .25;
    }

    And here's a good JavaScript board:
    http://www.codingforums.com/forumdis...p?s=&forumid=2
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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