Filter Data To Compile A Report???

every month i compile a Customer Spend Report for my sales manager.

I currently do this by:

1) Taking my database into table view.
2) Setting the date to Asend.
3) Then copy all jobs from the first day of the month to the last day
eg: June 1st - 29th.
4) Copy the data
5) paste into excel
6) Set auto filter on excel
7) Copy & Paste each customers spend to an individual sheet.

This is very painful! Esp when i know that since all the data i need is in the database and there is a way to get my DB to do this for me.

I have created a query to pull the data out of the database.
Then made a report using the query as the "location of data"

Right i have the report now pulling out the data and showin how i want it.

It shows the groupin of jobs by "Customer Name"

I now want to set a filter to it so that i can tell it to give me the report for all customers for just one month.

EG: June 07.

That way i wil have the data shown as:

Customer:
Month: June07
Cost For Doin Job:
Total Charge Out:
Profit:

How do i do this??? I know it has to be done within the query but i cant work out how to set it.

If any one can help that would b great!!!

thanks in advance!
gary