INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Report repeats Detail section

Report repeats Detail section

(OP)
Hello All,

In the attached (Access 2000) database, the report repeats the Detail section once for every invoice from which it draws data. So, what should be a 3-page report on 10 invoices becomes a 30-page report with the same information repeated on pages 4 through 30. A 2-page report on 6 invoices becomes a 12-page report with the same information repeated on pages 3 through 12. What I'd like to happen is to see the information only once.
Open frmReports. Click the Invoice Totals button. In the Set Date Range form, leave the From date as 1/01/2007. Set the To date to today. You'll see the 30-page report that should be only 3 pages. If the From date is 1/07/2014 and the To date is 30/06/2015, you'll see the 12-page report that should only be 2 pages.
I've spent hours trying to figure it out. Hopefully some fresh eyes can make proper sense out of it.

Thanks in advance,

Phillip

RE: Report repeats Detail section

It looks like you haven't set any link master/child properties.

I'm not sure I understand your table structures. You seem to be storing both details and summary data in the same table.

Duane
Hook'D on Access
MS Access MVP

RE: Report repeats Detail section

(OP)
As usual, I was making things more difficult than they actually are. The problem was that the main report was bound to a query that returned multiple invoice numbers, so the subreports in the detail section repeated themselves the corresponding number of times. Making the main report unbound solved the problem, and changing the way frmSetDateRange opens it (If Me!txtrptName = "rptRevenueByClient" Or Me!txtrptName = "rptInvoiceTotals" Then...) eliminated the prompt for dfldDate. I hope this post may assist anyone with a similar issue.

P

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close