Post reply

Combining 3 Queries to produce final SUM

  • March 1, 2006 at 7:29 am

    #111278

    I have to combine 3 huge queries to get a GT for ProjGross (see calcs.xls on forumulas).  Please check out ProjGross here

    http://www.photopizzaz.biz/projgross.txt

    and see this for the logic for projgross

    http://www.photopizzaz.biz/calcs.xls

    I am trying to combine (Daily Run Rate * Days Remaining )+ InHouse1 as (stated in the xls) using the previous select statements respectively to get my final ProjGross

     
    All queries so far in my projgross.txt work great...now I just need to combine what's needed to move forward in my calcs.xls to create ProjGross...at the Company level.
     
    You'll see that I attempted to start the ProjGross Query in my .txt file

  • March 1, 2006 at 8:37 am

    #624007

    resolved this on my own so please disregard post now.

     

     

  • March 1, 2006 at 11:11 am

    #624072

    Hi dba321,

    its always good to post your solution if you have managed to solve the task yourself, as this will help other people who may have similar problem in the further and search the forums.

    Trys

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply