Sum if no value?

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

    Sum if no value?

    hELLO,

    I have a text box in my report that have the the below formula that
    sum the quantity of shipments not on time. Up to here, everything is
    good, but now i try to figure how can I sum
    if there is no value?
    =Sum([SumOfDifférence de Journée])

    Please help!!!

    Thank you!
    Fred's
    Tags: None
    • Chris O'C via AccessMonster.com
      #2
      Re: Sum if no value?

      By Jet's reckoning, null + null + null doesn't add up to any number. If you
      want to show 0 in your report when there aren't any shipments not on time,
      use the NZ function. Like this:

      sum(nz([SumOfDifférenc e de Journée], 0))

      Chris
      Microsoft MVP


      Fred's wrote:
      >hELLO,
      >
      >I have a text box in my report that have the the below formula that
      >sum the quantity of shipments not on time. Up to here, everything is
      >good, but now i try to figure how can I sum
      >if there is no value?
      >=Sum([SumOfDifférenc e de Journée])
      >
      >Please help!!!
      >
      >Thank you!
      >Fred's
      --
      Message posted via AccessMonster.c om
      http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1


        Comment

        • Fred's
          #3
          Re: Sum if no value?

          On Jun 30, 4:15 pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
          wrote:
          By Jet's reckoning, null + null + null doesn't add up to any number.  If you
          want to show 0 in your report when there aren't any shipments not on time,
          use the NZ function.  Like this:
          >
              sum(nz([SumOfDifférence de Journée], 0))
          >
          Chris
          Microsoft MVP
          >
          Fred's wrote:
          hELLO,
          >
          I have a text box in my report that have the the below formula that
          sum the quantity of shipments not on time. Up to here, everything is
          good, but now i try to figure how can I sum
          if there is no value?
          =Sum([SumOfDifférence de Journée])
          >
          Please help!!!
          >
          Thank you!
          Fred's
          >
          --
          Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2008...
          Hello,

          I need to sum the total of shipment not in time when there is no data.

            Comment

            • Chris O'C via AccessMonster.com
              #4
              Re: Sum if no value?

              Maybe I don't understand your question. What does your report show when you
              use your original expression, =Sum([SumOfDifférenc e de Journée]) when there's
              no data and what does it show when you use the NZ function in your expression,
              =sum(nz([SumOfDifférenc e de Journée], 0)) when there's no data? My thinking
              is that it should show 0 as the sum when there's no data. Is that not what
              you want?

              Chris
              Microsoft MVP


              Fred's wrote:
              >On Jun 30, 4:15 pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
              >wrote:
              >By Jet's reckoning, null + null + null doesn't add up to any number.  If you
              >want to show 0 in your report when there aren't any shipments not on time,
              >[quoted text clipped - 20 lines]
              >--
              >
              >Hello,
              >
              >I need to sum the total of shipment not in time when there is no data.
              --
              Message posted via AccessMonster.c om
              http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200807/1


                Comment

                • Arch
                  #5
                  Re: Sum if no value?

                  On Thu, 3 Jul 2008 10:05:59 -0700 (PDT), "Fred's"
                  <frederic10_mes s@hotmail.comwr ote:
                  >On Jun 30, 4:15 pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
                  >wrote:
                  >By Jet's reckoning, null + null + null doesn't add up to any number.  If you
                  >want to show 0 in your report when there aren't any shipments not on time,
                  >use the NZ function.  Like this:
                  >>
                  >    sum(nz([SumOfDifférence de Journée], 0))
                  >>
                  >Chris
                  >Microsoft MVP
                  >>
                  >Fred's wrote:
                  >hELLO,
                  >>
                  >I have a text box in my report that have the the below formula that
                  >sum the quantity of shipments not on time. Up to here, everything is
                  >good, but now i try to figure how can I sum
                  >if there is no value?
                  >=Sum([SumOfDifférence de Journée])
                  >>
                  >Please help!!!
                  >>
                  >Thank you!
                  >Fred's
                  >>
                  >--
                  >Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2008...
                  >
                  >Hello,
                  >
                  >I need to sum the total of shipment not in time when there is no data.
                  Perhaps there is a small difficulty here with translation. Do you mean
                  that you need a Count of records for which [SumOfDifference de
                  Journee] is null?

                    Comment

                    Previous template Next
                    Working...