Summing groups in a report

[WorkRelated]

I have created a database that holds information regarding jobs our company
has fitted, the main information held is the fitting team, start date of job,
finish date of job and the nett cost of the job. From this I have a query
with the parameters set to ask for a Between And for the start date and the
finish date. The report is grouped into fitting team then month with a total
per team per month, then a total of every job in the footer.

When running a report for April figures - I enter the start date parameters
as 01-03-09 to 30-04-09 so I can see every job that has finished in April as
this tells me the figure we have invoiced out in April.

Finish Date I enter 01-04-09 to 31-05-09 as this tells me the figure we
should be getting charged for the supply of the products.

I would like the total in the footer to only sum together the jobs that have
finished in April, at the moment I am getting a total of all the jobs, I know
this is the parameters I have set so the total is correct but the purpose of
the report is to combine many reports I am running at the moment into one and
get the figure of jobs finished in April.

I am struggling to do this so it will work for every report run. IE May
report will be for jobs started between 01-04-09 to 31-05-09 and jobs
finished between 01-05-09 to 01-06-09 only adding nett value of jobs finish
in May. Maybe I have set the query up incorrectly please help if this is
possible. Thanks in advance

 

[Arvin Meyer [MVP]]

So build another group level for months. Make that the first group level.
Your report won't look exactly the same because each of the subgroups will
be repeated, but that's really what you are asking for anyway.