Extra Records

[tkosel]

I have a Query as illustrated below.

SELECT TempDisrepancyReportTableAllUsers.*_
FROM (TempDisrepancyReportTableAllUsers LEFT JOIN USER_TRAINING_RECORDS_
ON TempDisrepancyReportTableAllUsers.Training_Doc_ID =
USER_TRAINING_RECORDS.TRAINING_DOCUMENT_TAKEN)_
RIGHT JOIN TrainingDocsQueueTable ON
TempDisrepancyReportTableAllUsers.Training_Doc_ID =_
TrainingDocsQueueTable.Training_Doc_ID_
WHERE (((USER_TRAINING_RECORDS.TRAINING_DOCUMENT_TAKEN) Is Null));

This query by itself yields 1 record (I filter on a field named ClockNumber
for testing.)

ClockNumber is a field in the TempDisrepancyReportTableAllUsers table.

This query is my record source for a report which I group by ClockNumber.
When the report
runs, I get one grouping for the ClockNumber, but 4 detail records which are
identical to
each other.

Any Ideas?