Welcome to SPN

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

Sign Up Now!

subtotal for a group

Discussion in 'Information Technology' started by cmk, Nov 11, 2005.

Tags:
  1. cmk

    cmk
    Expand Collapse
    Guest

    I have a database with stockholder information. It has a stock certificate
    table that carries the orginal # of stocks purchased and I have a transaction
    file that contains selling of the stock. The two files are linked by
    stockholder, certificate number, and stock type

    I am trying to get a subtotal of my ending balance of shares by stock type.
    But I cannot figure out how to have a running total of my original purchased
    stock shares by group stock type. Then another field with a subtotal of
    total changes. If I can get those two numbers then I can sum them to come up
    with an ending share balance by stock type

    any help is appreciated thanks
     
  2. Loading...


  3. [MVP] S.Clark

    [MVP] S.Clark
    Expand Collapse
    Guest

    Running sums are super easy(bit switch) in Reports, but a pain in queries.

    --
    Steve Clark, Access MVP
    http://www.fmsinc.com/consulting
    *FREE* Access Tips: http://www.fmsinc.com/free/tips.html

    "cmk" <cmk@discussions.microsoft.com> wrote in message
    news:E1C9897C-7A6B-42EF-B104-845322913A9F@microsoft.com...
    >I have a database with stockholder information. It has a stock certificate
    > table that carries the orginal # of stocks purchased and I have a
    > transaction
    > file that contains selling of the stock. The two files are linked by
    > stockholder, certificate number, and stock type
    >
    > I am trying to get a subtotal of my ending balance of shares by stock
    > type.
    > But I cannot figure out how to have a running total of my original
    > purchased
    > stock shares by group stock type. Then another field with a subtotal of
    > total changes. If I can get those two numbers then I can sum them to come
    > up
    > with an ending share balance by stock type
    >
    > any help is appreciated thanks
     

Share This Page