crystalfun
Programmer
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?
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?