Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    28

    Unhappy Unanswered: how can i calculate in query the total!

    Group Name Borrows_db_daily loans_cr_daily
    Trades 7259 1947 0
    Transactions 13 12
    Transactions 0 0
    Transactions 16 31
    Transactions 58 930
    Transactions 58 1562
    Transactions 1 5798
    Transactions 926 566
    Transactions 0 0
    Transactions 5 0
    Transactions 13 0
    Transactions 8 0
    Transactions 0 0
    Transactions 0 3
    Transactions 47 47
    Transactions 0 0
    Transactions 1 1


    this is my table how can i come with the formula so i can have total of transaction rather than all these transactions..cuz they are brief discription of transaction..
    i only want trade and transaction where transaction are added i need help ASAP!!! i woudl be glad if someone can help on that!!

  2. #2
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    You can create a "Totals" query by clicking on the summation button in the query design. Change the total property from "Group by" to "Sum" for Borrows_db_daily and loans_cr_daily, but leave it as "Group by" for Group Name.

    The SQL will look like this (if your table name is tblGroups)

    Code:
    SELECT tblGroups.[Group Name], Sum(tblGroups.Borrows_db_daily) AS SumOfBorrows_db_daily, Sum(tblGroups.loans_cr_daily) AS SumOfloans_cr_daily
    FROM tblGroups
    GROUP BY tblGroups.[Group Name];

Posting Permissions

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