Creating A Query To Add Up Numbers

Hello

Bascially I am trying to make a query to check if certain Parameters are met over all in the table then add up records.

For example i have a record set up like

Bob Brown|Access Programmers|18/3/08|1
Bob Brown|Access Programmers|17/3/08|5

I would want to make a query compound those records up in a report (e.g the compounded values don't need to be saved just displayed)

If the records name field is the same and the dates fall in a certain range then the records will be compounded together e.g the numbers being added up

So the end result for that example would be

Bob Brown|Access Programmers|6

Because the records name and "Access Programmers" is the same and they fall within a certain date range the records are compounded together

My question is, Would you make a query to do that or can it be done with a report. Bascially what would be the best way to do it.:)

Thankyou In Advance!