Please help me get rid of the duplicates!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, I have a report, with a subreport. Everything is working perfectly
except one thing. If the subreport shows more then one entry, the report
(which actually generates a letter) is duplicated exactly.

Example: Letter one (ScopeID) has 2 entries (SCID), showing 2 separate
values, letter two has one entry with one value. Page two shows an exact
duplicate of page one with the data for letter one followed by one page for
letter two.

I have the subreport set to Sort/Group by my ScopeID (which is the ID for
each Letter), the ScopeID is in both the Report and Supreport (hidden).

The letters are perfect except for this one glitch, HELP!
 
This is usually caused by having an extra level of detail in your main report
that should not be there. You may need to remove a table from your main
report's record source.

If you can't figure this out, come back with more details about your record
sources and relationships.
 
Back
Top