So easy I feel stupid asking...Subtotals in a Query

[crystalfun]

Table Name: tbl project
Field Names:
Co
Dept
Acct
Project
Balance

This table is sorted ascending by Project #. I want to create a query showing Co, Dept, Acct, Project, & Balance. Then at each change in PROJECT I want to subtotal the amount of BALANCE so that I see the individual amounts and then a subtotal line much you can do in Excel. How can this be done?

 

[mpastore]

Create a query and paste this into it:

Table Name: tbl project
Field Names:
Co
Dept
Acct
Project
Balance

select Co
,Dept
,Acct
,Project
,sum([balance]) as bal_sum
from [tbl project]
group by Co
,Dept
,Acct
,Project

 

[crystalfun]

Thanks for the SELECT statement. However this does not subtotal at each change in Project. Can Access do this or do I have to stick to Excel?

 

[mpastore]

Can you paste some data to show what you mean?