• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 787
  • Last Modified:

Access Report - Detail section printing 2 lines per record

There is only 1 record per item in my table but the report prints 2 detail lines per record and not consecutively.  My database shows the records in a form.  In the form there is a print button which displays the report version of the same table for printing.  The form displays 1 line per record properly but the report has exactly 2 detail lines per record from the same table.  

The report uses 2 groupings, by record type, then by department.  In the department group heading, the =sum(hours) also adds each record twice.  The subtotals match the double display of each record.

I have attached a sample of the report and have no idea where to start to fix this problem.  It seems so straight forward.

Thanks for the help!
Helen

 ReportSample.pdf
0
greenprg
Asked:
greenprg
  • 4
  • 3
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Helen,

  Open the query that the report is based on and see if your getting one or two records for what your expecting to print.

JimD.
0
 
greenprgAuthor Commented:
The form uses a query just for sorting.  There is nothing in the criteria for filtering records.  I want all the records from the table.  The report is bound to the table with no query to get all the records.

Helen
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<The report is bound to the table with no query to get all the records.>>

  I'm a little baffeled by that then.  If the table has only one record, then that's what the report should be seeing.

  Can you possibly upload a DB with just the table and the report?  or e-mail it direct to me if you don't want to post publically?

  Outside of you doing something in code, there is nothing that would account for this that I can think of.

  You are using the detail section to print the individual records correct?

JimD.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
greenprgAuthor Commented:
OK, here's a stripped down version of my database.  Select the CRN/DAF # then the Review button.  The Details button shows the form which shows the records correctly.  The Print button shows the report which has 2 detail lines per record.  The records are in the ReportTempDtl table.

Thank you.
Helen
 RptTest.accdb
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Helen,

  Your report's data is based on a SELECT statement in the recordsource property of the report that joins DAF_Log, AssessmentTable, and ReportTempDtl.

  The  AssessmentTable has two records in for the current DAFNo, so your getting two records for each record in DAF_Log.

JimD.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

BTW, your form is only based on AssessmentTable and ReportTempDtl.

JimD.

0
 
greenprgAuthor Commented:
Cool!  Thanks!  I didn't even think to look at the report recordsource.  A prior version of the report did not use the query and the coding was saved in the recordsource.  I knew I was missing something obvious.

Helen
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now