Solved

Access Report - Detail section printing 2 lines per record

Posted on 2011-03-03
7
772 Views
Last Modified: 2012-05-11
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
Comment
Question by:greenprg
  • 4
  • 3
7 Comments
 
LVL 57
ID: 35030747
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
 

Author Comment

by:greenprg
ID: 35030950
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
 
LVL 57
ID: 35031075
<<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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Author Comment

by:greenprg
ID: 35031947
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
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 35032176
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
 
LVL 57
ID: 35032191

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

JimD.

0
 

Author Closing Comment

by:greenprg
ID: 35032645
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question