Solved

Access Report - Detail section printing 2 lines per record

Posted on 2011-03-03
7
777 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
[X]
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
  • 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
Technology Partners: 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!

 

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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.

726 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