Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Running totals not what I need?

Discussion in 'Information Technology' started by eb1mom, Nov 2, 2005.

Tags:
  1. eb1mom

    eb1mom
    Expand Collapse
    Guest

    In a prior post I was given links to information about running totals. I have
    spent a couple days working with this and I'm not having any success. Perhaps
    I am going about things the wrong way. The end result report I am trying to
    make. First line, 4 items A, B, C, D, all with a quanity of 10. Second line a
    sale of 2 each items A and B. Third line new subtotal Item A quanity 8, Item
    B quanity 8, Item C quanity 10 and Item D quanity 10. Fourth would be
    another sale and fifth a new subtotal etc. I only seem to be able to get
    running sum to work for a single item not multiple. Any suggestions for a
    different approach would be appreciated. Thank-you
     
  2. Loading...


  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    I did not understand your post. Please give a sample of data and then what
    you expect the results to be like --
    Data--
    A 23 31
    A 5 9
    B 4 5

    Results--
    A 28 40
    B 4 5

    "eb1mom" wrote:

    > In a prior post I was given links to information about running totals. I have
    > spent a couple days working with this and I'm not having any success. Perhaps
    > I am going about things the wrong way. The end result report I am trying to
    > make. First line, 4 items A, B, C, D, all with a quanity of 10. Second line a
    > sale of 2 each items A and B. Third line new subtotal Item A quanity 8, Item
    > B quanity 8, Item C quanity 10 and Item D quanity 10. Fourth would be
    > another sale and fifth a new subtotal etc. I only seem to be able to get
    > running sum to work for a single item not multiple. Any suggestions for a
    > different approach would be appreciated. Thank-you
     
  4. eb1mom

    eb1mom
    Expand Collapse
    Guest

    I am trying for a report that would look like this.



    Items A B C D
    Amt. In Stock 10 10 10 10
    Sold 2 2 0 0
    Now In Stock 8 8 10 10
    Sold 0 0 4 4
    Now In Stock 8 8 6 6






    "KARL DEWEY" wrote:

    > I did not understand your post. Please give a sample of data and then what
    > you expect the results to be like --
    > Data--
    > A 23 31
    > A 5 9
    > B 4 5
    >
    > Results--
    > A 28 40
    > B 4 5
    >
    > "eb1mom" wrote:
    >
    > > In a prior post I was given links to information about running totals. I have
    > > spent a couple days working with this and I'm not having any success. Perhaps
    > > I am going about things the wrong way. The end result report I am trying to
    > > make. First line, 4 items A, B, C, D, all with a quanity of 10. Second line a
    > > sale of 2 each items A and B. Third line new subtotal Item A quanity 8, Item
    > > B quanity 8, Item C quanity 10 and Item D quanity 10. Fourth would be
    > > another sale and fifth a new subtotal etc. I only seem to be able to get
    > > running sum to work for a single item not multiple. Any suggestions for a
    > > different approach would be appreciated. Thank-you
     
  5. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    What does your data look like that will be used in building the report?

    "eb1mom" wrote:

    > I am trying for a report that would look like this.
    >
    >
    >
    > Items A B C D
    > Amt. In Stock 10 10 10 10
    > Sold 2 2 0 0
    > Now In Stock 8 8 10 10
    > Sold 0 0 4 4
    > Now In Stock 8 8 6 6
    >
    >
    >
    >
    >
    >
    > "KARL DEWEY" wrote:
    >
    > > I did not understand your post. Please give a sample of data and then what
    > > you expect the results to be like --
    > > Data--
    > > A 23 31
    > > A 5 9
    > > B 4 5
    > >
    > > Results--
    > > A 28 40
    > > B 4 5
    > >
    > > "eb1mom" wrote:
    > >
    > > > In a prior post I was given links to information about running totals. I have
    > > > spent a couple days working with this and I'm not having any success. Perhaps
    > > > I am going about things the wrong way. The end result report I am trying to
    > > > make. First line, 4 items A, B, C, D, all with a quanity of 10. Second line a
    > > > sale of 2 each items A and B. Third line new subtotal Item A quanity 8, Item
    > > > B quanity 8, Item C quanity 10 and Item D quanity 10. Fourth would be
    > > > another sale and fifth a new subtotal etc. I only seem to be able to get
    > > > running sum to work for a single item not multiple. Any suggestions for a
    > > > different approach would be appreciated. Thank-you
     
  6. eb1mom

    eb1mom
    Expand Collapse
    Guest

    Query for current items in stock has two fields, items and amounts, grouped
    by items and sum for amounts. Query for sales has two fields, items and
    amount sold. I am thinking if there are four different items, there needs to
    be an amount sold for each. One item sale, would need three other zero sale
    records?
     
  7. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    I guess I was not clear as I asked that you show a sample of your data that
    would be used in the report. Like --
    Item Sold Stock
    A 5 6
    B 3 4
    A 1 5
    C 9 4

    Or however your data is stored.

    "eb1mom" wrote:

    > Query for current items in stock has two fields, items and amounts, grouped
    > by items and sum for amounts. Query for sales has two fields, items and
    > amount sold. I am thinking if there are four different items, there needs to
    > be an amount sold for each. One item sale, would need three other zero sale
    > records?
    >
    >
     
  8. eb1mom

    eb1mom
    Expand Collapse
    Guest

    Sorry, I misunderstood what you asked.


    Items in stock query


    Item Amount
    A15 20
    B12 30
    C17 10
    D16 40


    Items sold query


    AutoNumber Item Amount
    1 A15 3
    2 D16 1
    3 C17 2
    4 A15 4
    5 C17 6
    6 B12 1
    7 D16 3
    8 C17 3
    9 A15 4
    10 B12 5

    Report would look like


    Item A15 B12 C17 D16

    Amount in Stock 20 30 10 40
    Sold 3 X X X
    Now in Stock 17 30 10 40
    Sold X X X 1
    Now in Stock 17 30 10 39
    Sold X X 2 X
    Now in Stock 17 30 8 39
    Sold 4 X X X
    Now in Stock 13 30 8 39
    Sold X X 6 X
    Now in Stock 13 30 2 39
    Sold X 1 X X
    Now in Stock 13 29 2 39
    Sold X X X 3
    Now in Stock 13 29 2 36
    Sold X X 3 X
    Now in Stock 13 29 -1 36
    Sold 4 X X X
    Now in Stock 11 29 -1 36
    Sold X 5 X X
    Now in Stock 11 24 -1 36
     

Share This Page