Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2016

    Unanswered: Discount box % (text boxes) dont work

    The discount box does not work properly. It is supposed show a % (SNPct) discount of the total amount (SNAmt). However, it does not do anything. Is there a way to solve this problem?



    SELECT PurchaseQuoteDtl.SnAmt, PurchaseQuoteDtl.Cost AS SCost, Round([SCost]*[SnPct]) AS Expr1, PurchaseQuoteDtl.SnPct

    FROM PurchaseQuoteDtl;

    Click image for larger version. 

Name:	Discount Box.jpg 
Views:	4 
Size:	15.8 KB 
ID:	17062

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    'it does not do anything' is a perfect dewscription of how not to ask for assitance
    ...what have you tried
    what isn't working
    what shoudl happen
    when should the discount be calculated

    if its is a discount that forms part of the contract, thenonce calcualted and the custoemr informed then it shoudl be frozen so that you can get back to that legal value.

    so over to you.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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