Please help me get rid of the duplicates!

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!
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change font formatting for part of a field in a report 3
Two Criteria 3
Grrrrr Please Help!! 2
Get rid of empty space 1
Help Please 3
Need help with combo box lookup reference in a report 6
Report with disappearing subreports - null values 3
Printing Data Horizontally 1

Top