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

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").

cheers sorted.