Ending up with 2 records per date

[Guest]

I have a query set up and I am ending up with 2 records for each date. Here
is the SQL view of the qry. What Am I doing wrong?

SELECT tblForecastReports.FCDate, tblForecastReports.fcrCurLTLLns,
tblForecastReports.fcrPD1LTLLns, tblForecastReports.fcrPD2LTLLns,
[fcrCurLTLLns]+[fcrPD1LTLLns]+[fcrPD2LTLLns] AS [TOTAL LTL Lines],
[qryDeptLTLPrfmPerHour Query].[Avg Of LTLLPH], [TOTAL LTL Lines]/[Avg of
LTLLPH] AS AroxNeedHoursLTL
FROM qryDeptHoursPrfmMonthly, [qryDeptLTLPrfmPerHour Query],
tblForecastReports;

 

[[MVP] S.Clark]

I expected to see a GROUP BY clause, but guess that it is hidden in the
qryDeptHoursPrfmMonthly

Without knowing it's contents, a reason for the 'dups' can't really be
given.


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html