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
    Why Are There Different Versions Of Bhai Nand Lal's Rehitnama? Please Help Clarify Questions and Answers Mar 7, 2017
    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

  3. OP
    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)
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page