Results 1 to 5 of 5

Thread: Sum Records

  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: Sum Records

    Could anyone tell me how to sum the total of a record?
    I can do it by entering each field in the equation but it's quite long winded. Can I do one that is across the board no matter how many fields I have?

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    In the Report try to use a hidden textbox and make the Summation in every Group. Then use it the Sum of the totals

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    It's basically an inventory DB. I download Attribute_Tables from AutoCAD
    and send fixtures out to every store we have based on this (could be up to 180-200 this year).The Attribute_Table has the 'fixture name' and 'count' as fields and each fixture item as records
    I need a query to link all the stores Attribute_Tables with the 'InventoryonHand_Table' but would prefer to link just a total of each record rather than 180-200 different pieces of info.
    In excel what I want would simply be =sum(a1:a99) is there a formula I can use in Access that does this or do I have to rely on =A1+A2+A3.... etc?

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Actually, it's closer to your original example then you might think.

    Simply put =sum(yourField) in the FOOTER section for whatever you'd like to sum. I assume you are doing this with a report.
    oh yeah... documentation... I have heard of that.

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

  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Hi BigRedBus,

    Without seeing your database seems like you would have a field already for each record that holds the Totals. In your report, place that Totals field on it, then in the ReportFooter place a TextBox and call it SubTotals or something. In that TextBox (SubTotals) place your calculation for the Totals fields above...something like this:
    ---------------------------------------------------------------
    No. Item Qty
    1. Shoes 5
    2. Shirts 6
    3. Hats 10

    All that is in the ReportDetailSection.
    ---------------------------------------------------------------
    [SubTotals] =Sum([Qty])

    This line above goes in the ReportFooterSection
    ---------------------------------------------------------------

    That will give you the Total for all listed items above that have a Qty.

    have a nice one,
    Bud

Posting Permissions

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