Help with add/subtract

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Don
    #1

    Help with add/subtract

    I have a report that among other things has two text boxes. One reports the
    sum of charges, the other reports those charges minus any payments made
    against the charges (balance due). The problem I have is the text box that
    reports the balance due will not show anything until an entry is made into
    the payments field. In other words if the sum of charges is $100.00 and
    nothing has been paid against that the "balance due" field is blank, instead
    of showing $100.00.
    I can't seem to make it do this, can anyone help?
    Here's what I've got in the properties for the "balance due". Sum of
    Charges = text13, Balance due = Income.
    =[text13]-Sum([income])
    Thanks,
    Don..........


    Tags: None
    • Salad
      #2
      Re: Help with add/subtract

      Don wrote:[color=blue]
      > I have a report that among other things has two text boxes. One reports the
      > sum of charges, the other reports those charges minus any payments made
      > against the charges (balance due). The problem I have is the text box that
      > reports the balance due will not show anything until an entry is made into
      > the payments field. In other words if the sum of charges is $100.00 and
      > nothing has been paid against that the "balance due" field is blank, instead
      > of showing $100.00.
      > I can't seem to make it do this, can anyone help?
      > Here's what I've got in the properties for the "balance due". Sum of
      > Charges = text13, Balance due = Income.
      > =[text13]-Sum([income])
      > Thanks,
      > Don..........
      >
      >[/color]
      See if using NZ assists. Ex:
      NZ(Sum([income],0)

        Comment

        • Don
          #3
          Re: Help with add/subtract

          Would that look like this?
          =[text13]NZ(Sum([income],0)
          Sorry but I don't understand how to write this.
          Don............ ..
          "Salad" <oil@vinegar.co m> wrote in message
          news:6m4bf.120$ Id6.41@newsread 1.news.pas.eart hlink.net...[color=blue]
          > Don wrote:[color=green]
          > > I have a report that among other things has two text boxes. One reports[/color][/color]
          the[color=blue][color=green]
          > > sum of charges, the other reports those charges minus any payments made
          > > against the charges (balance due). The problem I have is the text box[/color][/color]
          that[color=blue][color=green]
          > > reports the balance due will not show anything until an entry is made[/color][/color]
          into[color=blue][color=green]
          > > the payments field. In other words if the sum of charges is $100.00 and
          > > nothing has been paid against that the "balance due" field is blank,[/color][/color]
          instead[color=blue][color=green]
          > > of showing $100.00.
          > > I can't seem to make it do this, can anyone help?
          > > Here's what I've got in the properties for the "balance due". Sum of
          > > Charges = text13, Balance due = Income.
          > > =[text13]-Sum([income])
          > > Thanks,
          > > Don..........
          > >
          > >[/color]
          > See if using NZ assists. Ex:
          > NZ(Sum([income],0)[/color]


            Comment

            • Wayne Gillespie
              #4
              Re: Help with add/subtract

              On Sat, 05 Nov 2005 17:15:32 GMT, "Don" <vze2t273@veriz on.net> wrote:

              =[Text13]-Sum(Nz([Income],0))
              [color=blue]
              >Would that look like this?
              >=[text13]NZ(Sum([income],0)
              >Sorry but I don't understand how to write this.
              >Don........... ...
              >"Salad" <oil@vinegar.co m> wrote in message
              >news:6m4bf.120 $Id6.41@newsrea d1.news.pas.ear thlink.net...[color=green]
              >> Don wrote:[color=darkred]
              >> > I have a report that among other things has two text boxes. One reports[/color][/color]
              >the[color=green][color=darkred]
              >> > sum of charges, the other reports those charges minus any payments made
              >> > against the charges (balance due). The problem I have is the text box[/color][/color]
              >that[color=green][color=darkred]
              >> > reports the balance due will not show anything until an entry is made[/color][/color]
              >into[color=green][color=darkred]
              >> > the payments field. In other words if the sum of charges is $100.00 and
              >> > nothing has been paid against that the "balance due" field is blank,[/color][/color]
              >instead[color=green][color=darkred]
              >> > of showing $100.00.
              >> > I can't seem to make it do this, can anyone help?
              >> > Here's what I've got in the properties for the "balance due". Sum of
              >> > Charges = text13, Balance due = Income.
              >> > =[text13]-Sum([income])
              >> > Thanks,
              >> > Don..........
              >> >
              >> >[/color]
              >> See if using NZ assists. Ex:
              >> NZ(Sum([income],0)[/color]
              >[/color]

                Comment

                • Don
                  #5
                  Re: Help with add/subtract

                  Thank you. It works and I've been able to put it into a couple of other
                  fields.
                  If you don't mind explaining and have the time would you tell me briefly
                  what Nz does?
                  Thanks,
                  Don.........
                  "Wayne Gillespie" <bestfit@NOhotm ailSPAM.com.au> wrote in message
                  news:qteqm1thpa 8v584i1sr36tk3b 68o8c6bf5@4ax.c om...[color=blue]
                  > On Sat, 05 Nov 2005 17:15:32 GMT, "Don" <vze2t273@veriz on.net> wrote:
                  >
                  > =[Text13]-Sum(Nz([Income],0))
                  >[color=green]
                  > >Would that look like this?
                  > >=[text13]NZ(Sum([income],0)
                  > >Sorry but I don't understand how to write this.
                  > >Don........... ...
                  > >"Salad" <oil@vinegar.co m> wrote in message
                  > >news:6m4bf.120 $Id6.41@newsrea d1.news.pas.ear thlink.net...[color=darkred]
                  > >> Don wrote:
                  > >> > I have a report that among other things has two text boxes. One[/color][/color][/color]
                  reports[color=blue][color=green]
                  > >the[color=darkred]
                  > >> > sum of charges, the other reports those charges minus any payments[/color][/color][/color]
                  made[color=blue][color=green][color=darkred]
                  > >> > against the charges (balance due). The problem I have is the text[/color][/color][/color]
                  box[color=blue][color=green]
                  > >that[color=darkred]
                  > >> > reports the balance due will not show anything until an entry is made[/color]
                  > >into[color=darkred]
                  > >> > the payments field. In other words if the sum of charges is $100.00[/color][/color][/color]
                  and[color=blue][color=green][color=darkred]
                  > >> > nothing has been paid against that the "balance due" field is blank,[/color]
                  > >instead[color=darkred]
                  > >> > of showing $100.00.
                  > >> > I can't seem to make it do this, can anyone help?
                  > >> > Here's what I've got in the properties for the "balance due". Sum[/color][/color][/color]
                  of[color=blue][color=green][color=darkred]
                  > >> > Charges = text13, Balance due = Income.
                  > >> > =[text13]-Sum([income])
                  > >> > Thanks,
                  > >> > Don..........
                  > >> >
                  > >> >
                  > >> See if using NZ assists. Ex:
                  > >> NZ(Sum([income],0)[/color]
                  > >[/color]
                  >[/color]


                    Comment

                    • Wayne Gillespie
                      #6
                      Re: Help with add/subtract

                      On Sun, 06 Nov 2005 12:30:01 GMT, "Don" <vze2t273@veriz on.net> wrote:

                      The Nz function converts a Null value into the value specified by the second argument in this case 0.
                      A Null value cannot be included in a general maths equation as it has no value, so by converting the value to 0 it
                      allows the equation to be calculated.
                      [color=blue]
                      >Thank you. It works and I've been able to put it into a couple of other
                      >fields.
                      >If you don't mind explaining and have the time would you tell me briefly
                      >what Nz does?
                      >Thanks,
                      >Don.........
                      >"Wayne Gillespie" <bestfit@NOhotm ailSPAM.com.au> wrote in message
                      >news:qteqm1thp a8v584i1sr36tk3 b68o8c6bf5@4ax. com...[color=green]
                      >> On Sat, 05 Nov 2005 17:15:32 GMT, "Don" <vze2t273@veriz on.net> wrote:
                      >>
                      >> =[Text13]-Sum(Nz([Income],0))
                      >>[color=darkred]
                      >> >Would that look like this?
                      >> >=[text13]NZ(Sum([income],0)
                      >> >Sorry but I don't understand how to write this.
                      >> >Don........... ...
                      >> >"Salad" <oil@vinegar.co m> wrote in message
                      >> >news:6m4bf.120 $Id6.41@newsrea d1.news.pas.ear thlink.net...
                      >> >> Don wrote:
                      >> >> > I have a report that among other things has two text boxes. One[/color][/color]
                      >reports[color=green][color=darkred]
                      >> >the
                      >> >> > sum of charges, the other reports those charges minus any payments[/color][/color]
                      >made[color=green][color=darkred]
                      >> >> > against the charges (balance due). The problem I have is the text[/color][/color]
                      >box[color=green][color=darkred]
                      >> >that
                      >> >> > reports the balance due will not show anything until an entry is made
                      >> >into
                      >> >> > the payments field. In other words if the sum of charges is $100.00[/color][/color]
                      >and[color=green][color=darkred]
                      >> >> > nothing has been paid against that the "balance due" field is blank,
                      >> >instead
                      >> >> > of showing $100.00.
                      >> >> > I can't seem to make it do this, can anyone help?
                      >> >> > Here's what I've got in the properties for the "balance due". Sum[/color][/color]
                      >of[color=green][color=darkred]
                      >> >> > Charges = text13, Balance due = Income.
                      >> >> > =[text13]-Sum([income])
                      >> >> > Thanks,
                      >> >> > Don..........
                      >> >> >
                      >> >> >
                      >> >> See if using NZ assists. Ex:
                      >> >> NZ(Sum([income],0)
                      >> >[/color]
                      >>[/color]
                      >[/color]

                        Comment

                        Previous template Next
                        Working...