Microsoft Access Report Outputs

[Nadeem]

Hi,

I have a ''Main'' table which contains all the data. There is another
table, "StartEndDates", that the user puts a start date and an end
date into. The "Quarterly" Report is to output data from the Main
table based on the start and end dates requested by the user. The
start and end dates is for a range of dates in which the part was
recieved i.e. "Received Date".

I need to output a count of the number of records in that time range.
I am able to output this in the report if there is only one start date
and one end date. The problem is when I put in more than one start
date and end date. I want to be able to output the numbers from all
the date ranges without overriding the previous one. I'm putting in
the code in the "control source" of the text box in the report.

This is what I have done so far.
-Create a query that outputs records between start and end dates that
the user put in the StartEndDates table.
-In the report, use the dcount function (in the control source field)
to count the number of records.
-The report output:

1Q2007
Totals:
Count of PartX:
Count of PartY:
Count of PartZ:

2Q2007
Totals:
Count of PartX:
Count of PartY:
Count of PartZ:

One last thing: Totals, PartX, PartY, and PartZ are total count up
until the end of quarter. In other words, its not the totals for just
that quarter.