Finding a sum total in a query after using an expression

[El Burro]

Again a straight forward problem.

I am running a query that selects all work done on a project by a staff member within certain parameter dates. This involves using an expression that adds together the hours worked each day on a project and giving a bi-weekly total. Whilst this does give me all the records for a query it does not add them together. Displaying:

Name Project Hours
Joe Fish 271B 10
Joe Fish 271B 5
Joe Fish 300B 6
Ann Spoon 400B 4
Ann Spoon 400B 6

rather than

Name Project Hours
Joe Fish 271B 15
Joe Fish 300B 6
Ann Spoon 400B 10

In order to get this format i am having to run a 2nd query on the original to provide a sum total. Whilst this works I am sure there is an easier way but cannot find one.

Any help????

 

[shacket]

Easy. Just click on the Totals button (the sigma next to the 'Add Tables' button) and choose "Sum" in the column you wish to add (in your case, "Hours").

 

[El Burro]

cheers sorted.