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

    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
    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:
    J. Paul Schmidt, Freelance Web and Database Developer
    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