Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    54

    Unanswered: Problematic query

    Hi everyone,
    I have no problem of writing a query for RunBal but I have difficulty of trying to write a query on FinalBal. Can someone please help ?

    ID Item ItemNo InQty Sold RunBal FinalBal
    1 Fork 6105 8 2 6 6
    2 Pan 6302 4 1 3
    3 Pan 6302 2 2 3 3
    4 Pot 7312 5 1 4
    5 Pot 7312 2 3 3
    6 Pot 7312 6 2 7 7
    7 Pot 8204 9 5 4 4
    Last edited by big_mon; 05-28-11 at 06:12.

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    What is the difference between running balance and final balance?

    Also, I see some records have all fields filled in, some don't. Why is that? Also, it seems that you're mixing inventory data with order data. Why are you doing that?

    Sam

  3. #3
    Join Date
    Jan 2008
    Posts
    54
    My invoice may have same item but different item no. So I need to find out what is the final balance of say, Pot . I will have to show in the report the running balance and the total balance of all pots from the same invoice. If I can use the query as record source I can show the runbal, SubBal and Total values in the report.

    The report will be something like this:

    Date ItemNo InQty Sold RunBal
    Pot

    InvNo: H26535

    20/06/2010 7312 5 1 4
    22/08/2010 2 3 3
    23/12/2010 6 2 7 <- - SubBal
    .............................. ......
    31/04/2010 8204 9 5 4
    23/12/2010 0 0 4 < - - SubBal
    --------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    Total 11 < - - - the final balance field (7+4)

Posting Permissions

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