Welcome to SPN

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

Sign Up Now!

Adding 2 different Rows

Discussion in 'Information Technology' started by JOM, Nov 18, 2005.

  1. JOM

    JOM
    Expand Collapse
    Guest

    I have fieldx in tble1 and fieldy in tble2 I would like to add them up by row
    ie. and put that information in tble3
    the thing is that if tble2 does not have a matching record,but tble1 has
    something then report returns nothing!

    Sum([tble1].fieldx +[tble2].fieldy)
     
  2. Loading...

    Similar Threads Forum Date
    Leisure Okay, so I am trying to sing in a different language... Business, Lifestyle & Leisure Jul 8, 2014
    How many different types of Sikhs are there? Sikh Sikhi Sikhism Jul 8, 2014
    Gurbani of a Different Flavour Intellectual Translations by SPNers Oct 29, 2013
    Leisure If you could go back in time, what would you do differently? Business, Lifestyle & Leisure Aug 25, 2013
    Opinion Facing Adversity - Different Reactions Breaking News Aug 18, 2013

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Try this --
    Sum(Nz([tble1].fieldx) +Nz([tble2].fieldy))

    "JOM" wrote:

    > I have fieldx in tble1 and fieldy in tble2 I would like to add them up by row
    > ie. and put that information in tble3
    > the thing is that if tble2 does not have a matching record,but tble1 has
    > something then report returns nothing!
    >
    > Sum([tble1].fieldx +[tble2].fieldy)
     

Share This Page