can't create a total field between three tables

Discussion in 'MS Access' started by sharon7, Dec 5, 2012.

  1. sharon7

    sharon7 New Member

    Joined:
    Feb 23, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    Hi,
    I am using MS Access 2010 on Windows System 7.

    I have three tables: A, B, C
    Table A has the field Task NO
    Table B has the fields Task No, PriorActuals
    Table C has the fields Task No, HoldbackActuals

    I need to create a query that tasks the Task No from Table A and matches it to Table B and Table C. I then need to show in the query the following:

    Task no PriorActuals HoldbackActuals Total

    My problem is that depending on how I connect the tables, different values are stored in the Total field. the Total field will either be all the data in the PriorActuals field or it will be all the data in the HoldbackActuals field. I can't get the total field to show PriorActuals + holdbackActuals.

    Please help. i have tried everything I can think of and I can't get it to work.

    Thanks
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice