Solved

Access Report - Detail section printing 2 lines per record

Posted on 2011-03-03
7
769 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

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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
Comment Utility
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

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
<<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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:greenprg
Comment Utility
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
Comment Utility
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

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility

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

JimD.

0
 

Author Closing Comment

by:greenprg
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now