Calculating Aggregate Total in A Select Query Which Has 1 Grouped Field and 1 Summed Field

[Galapagos15]

If I have a select query which groups "Company" and sums the "Blled Amt" how can I make an aggregate "Total" show in my results when the query is run? For example, I would want the $60 aggregate total to show when the query is run?

SQL Coding:

SELECT Table1.[Company], Sum(Table1.[Billed Amt]) AS [SumOfBilled Amt]
FROM Table1
GROUP BY Table1.[Company];


Current Results:

Company_______________SumOf BILLED AMT
C&O_______________________$10
Barner_____________________$20
Granger____________________$30

Desired Results:

Company_______________SumOf BILLED AMT
C&O_______________________$10
Barner_____________________$20
Granger____________________$30
Total-______________________$60

 

[strive4peace]

.1. open the datasheet
.2. click the Totals icon on the HOME ribbon in the Records group
.3. this adds another row to the bottom labeled "Total"
.4. click the Total cell in the Sum column and choose "Sum" from the dropdown list

 

[Galapagos15]

That works thanks a ton!

 

[strive4peace]

you're welcome, happy to help ~