Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate Pages

Status
Not open for further replies.
MikeKohler

MikeKohler

Technical User
Jun 22, 2001
115
CA
Hi, I have a report based on a query where each page contains a single record. For some reason duplicate pages show up. I changed the SQL statement in the query to SELECT DISTINCT so that duplicates would be skipped, but this doesn't really make sense since their are no duplicates in the underlying table.
Thank you,
Michael Kohler
mkohler@telusplanet.net
 
Sort by date Sort by votes
Start by running the query standalone, and work from there. Double check the report's recordsource, Filter and FilterOn too.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
497
dhookom
dhookom
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
362
dhookom
dhookom
RonMcIntire
  • Locked
  • Question
Preview multiple pages in a report
Replies
3
Views
215
dhookom
dhookom
VicM
  • Locked
  • Question
Duplicate record on first run of labels
Replies
4
Views
165
VicM
VicM
jpl458
  • Locked
  • Question
Can't stop one page report from using two pages on printer
Replies
2
Views
118
jpl458
jpl458

Part and Inventory Search

Sponsor

Back
Top