project number sum listing sql

[Sorttaaja2]

Hello!
I have a long list of projects in access in one table to check the sum of work hours.
Is there a way to get list of projects and their work hour sums with sql?


If not , is there a way to make sorting pop up as separate window?


thankyou very much!

 

[ranman256]

Yes, make a query, bring down: proj#, hrs
Turn on summing,
set SUM on hrs.