Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Donation box price visible not calculating

Discussion in 'Information Technology' started by lmv, Jul 28, 2006.

  1. lmv

    lmv
    Expand Collapse
    Guest

    I have a box that I ck if the amount was donated. I want the amount to show
    for tracking in the extended price field BUT I want it not to calculate with
    the rest of the extended price total on that order then at the end of my
    report I will have it show up as the total of donated materials.... (I have a
    "return box" which uses the following code that makes it negative... Is
    there something like this that would work?)

    Private Sub ckReturned_Click()

    If ckReturned.Value = True Then
    If UnitPrice.Value > 0 Then
    UnitPrice.Value = UnitPrice.Value * -1
    End If
    Else
    If UnitPrice.Value < 0 Then
    UnitPrice.Value = UnitPrice.Value * -1
    End If
    End If

    Thanks!
     
  2. Loading...


  3. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Lmv,

    No. Just leave the tick there. You can do the calculations you require
    on the report itself. For example, extended price total can be like this...
    =-Sum([Extended Price]*([Donated]=0))
    Donations total in the report footer can be like this...
    =-Sum([Extended Price]*[Donated])

    --
    Steve Schapel, Microsoft Access MVP

    lmv wrote:
    > I have a box that I ck if the amount was donated. I want the amount to show
    > for tracking in the extended price field BUT I want it not to calculate with
    > the rest of the extended price total on that order then at the end of my
    > report I will have it show up as the total of donated materials.... (I have a
    > "return box" which uses the following code that makes it negative... Is
    > there something like this that would work?)
    >
    > Private Sub ckReturned_Click()
    >
    > If ckReturned.Value = True Then
    > If UnitPrice.Value > 0 Then
    > UnitPrice.Value = UnitPrice.Value * -1
    > End If
    > Else
    > If UnitPrice.Value < 0 Then
    > UnitPrice.Value = UnitPrice.Value * -1
    > End If
    > End If
    >
    > Thanks!
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page