Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    32

    Unanswered: Create a sum field in a table

    Is it possible to create a a field that will sum in a table or is it only possible in a query?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    no not in a table ( why store total just store the data that make the total them you also see how the total was made up)

    Run a query over the table which will sum the value you want then use this Query in your reports/froms
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    When you want to know how much cash is in your wallet, do you open it up and count what you have or do you keep a slip of paper in it that you update every time you make a purchase?

    Just curious...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    good point teddy couldn't of put it beater.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #5
    Join Date
    Oct 2003
    Posts
    103

    Why would you want to?

    As the other guys eluded(sp?) to , what is your reasoning for wanting to store the sum. That might help us help you find the solution you are looking for.

    Logically, if you were to store a sum in the table, you'd have the same sum in every record for of that field.

    Alternatively, and this is what I do with inventory items, I keep a total for certain things in another table, and that gets "adjusted" when in the case of inventory, an item is received or used. In that case, I keep track of quantities for each location (in a table with information about the location), and then I keep the items (in a list format - FIFO/LIFO type deal in a seperate table). I can actually get at the aggregate total by totalling the sum of the locations for a given item, or by counting the items in the fifo/lifo table.

    Make sense?

Posting Permissions

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