Possible Sum Requirement

[stepdown]

I am sure this is very simple, but I'm not sure what it is that I'm looking for. As always I've spent time searching, but I don't really know what I'm searching for at the moment.

What it is I'm looking to do is to have a list of all the clients in the database, and then have the total number of hours charged next to them. While I could easily making a report listing all of the hours they have been charged for, and have a total of them at the bottom, I'm unsure of how to achieve this without a list.

I am assuming that there is a way to do this in a query. I looked into using a SUM function, but this seemed to be different from what I want. I am not looking for somebody to tell me what to do, but just to say what it is I'm looking for, I might even need to do it on the report.

Thanks for any pointers

 

[Rich]

Use a Totals query, GroupBy client and Sum Hours charged

 

[stepdown]

Thanks for that