Report/Subreport problem...

[MBison80]

Hello all,
still working on that calendar project but the light is at the
end of the tunnel. I have created a reort and this report has to
resemble a calendar view by month. I have broken the report into
subreports, one for date, day etc..etc... and I have this report that
displays just the records for 'Friday'. The report shows each issue for
that date. The query for the report displays the correct info but when
the report is in preview mode it displays four subreports for one date
and one for the next date. For example there are 4 entries for 4/9/04
but only one for 4/23/04. Strangely enough there are four issues for
the 9th and only one issue for the 23rd. The subreport is linked by
Duedate to Duedate. The query (that looks fine) is as below...

SELECT DISTINCT qryMonths.Issue, qryMonths.DueDate, qryMonths.Month,
qryMonths.DOW
FROM qryMonths
WHERE (((qryMonths.Month)="april") AND ((qryMonths.DOW)="Friday"));

The qryMonths is as follows....

SELECT DISTINCT tblCalendar.Issue, tblStatus.DueDate, tblMonth.Month,
Format([duedate],"dddd") AS DOW
FROM (tblCalendar LEFT JOIN tblStatus ON tblCalendar.CalID =
tblStatus.CalID) LEFT JOIN tblMonth ON tblStatus.Month =
tblMonth.Number
WHERE (((tblCalendar.Issue) Is Not Null) AND ((tblStatus.DueDate) Is
Not Null))
ORDER BY tblStatus.DueDate;


Can anyone see why these subreports repeat themselves for each issue
?

Regards,
Craig....