+ Reply to Thread
Results 1 to 2 of 2

Summing Amount party wise

  1. #1
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2007 Enterprise
    Posts
    726

    Summing Amount party wise

    Dear Members

    I have 6 total queries totling amount on party basis (6 individual tables.

    Now I am trying to evaluate (Plus or minis) the amount on party wise and appen it to another table (Trial Balance).

    In query No. 7 i have tried something but failed.

    Help me to solve the problem. (File attached)
    Any query or code will do

    Regards
    Attached Files Attached Files
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

  2. #2
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2007 Enterprise
    Posts
    726

    Re: Summing Amount party wise

    Dear Members
    I have solved it myself

    Take two tables at a time and create total query on party .
    Then another query with the above and a new one and so non.
    If you have query too comp;lex error, append the result of previous query and then continue with that table and another neew one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1