Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010

    Unanswered: So I am trying to perform a calculation on an asp page but

    I am kind of new to asp so not sure where to start.

    So I have these:

    <td align="right"><p>ʹҧ:</p></td>
    <td align="left">

    So intPrevious Total comes from this sql:

    rsPreviousTotal.Open "SELECT Total.[sumofextended price] AS Total FROM tbl_ShipOrders INNER JOIN qrycondetailsextendedtotals AS Total ON Total.ship_ID = tbl_shipOrders.ship_order_ID WHERE chkloaded = yes AND Paid = 1 AND payment_id = 4 AND Deposited = No AND Branch_ID = " & branchID, oCOnn, 1, 3

    after this:

    do while not rsPreviousTotal.EOF
    intPreviousTotal= intPreviousTotal + rsPreviousTotal(0)

    and the variables being declared and the initial value being set to zero just incase there is something stored in the cookies etc.

    So it works fine but now I want to perform a calculation from these totals to draw the balance from it. Basically deducting all the deductables from the total.

    Actually, I am looking for some advice on how I could go about doing it

  2. #2
    Join Date
    Feb 2010
    Actually I have managed it with:

    <td align="right"><p>Left:</p></td>
    <td align="left">

Posting Permissions

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