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!!
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)
SELECT tblGroups.[Group Name], Sum(tblGroups.Borrows_db_daily) AS SumOfBorrows_db_daily, Sum(tblGroups.loans_cr_daily) AS SumOfloans_cr_daily
GROUP BY tblGroups.[Group Name];