Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Access Report - Detail section printing 2 lines per record

Posted on 2011-03-03
7
774 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

828 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