If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Extra Records
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? |
Thread Tools | |
Display Modes | |
|
|