Results 1 to 6 of 6
  1. #1
    AArcher21 is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2018
    Posts
    3

    Report duplicating result

    I have a database report that pull information from different queries. The main report data source is inbound and the sub reports are the ones that pull data from the different queries. Now my issue is that the report is duplicating the fields. Example: the report suppose to show how many dates are <= 31 December 2018 (I wish I could set End of the Month instead, for future use), so if the answer is 43 records it will show that amount 43 times.


    I have try pretty much anything I can think of to correct the issue but I can’t. Any tips would be appreciated.

    Click image for larger version. 

Name:	01B637E6-729C-47B6-837F-9A222440CDAE.jpeg 
Views:	10 
Size:	42.9 KB 
ID:	36533

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Did you mean 'unbound'?

    Would need to see db structure and report design. If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    AArcher21 is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2018
    Posts
    3
    Yes I meant ‘unbound’. And I can’t provide the full database for security reasons.



    Quote Originally Posted by June7 View Post
    Did you mean 'unbound'?

    Would need to see db structure and report design. If you want to provide db for analysis, follow instructions at bottom of my post.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    If you can't provide a copy that is 'sanitized', doubt if I can help.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Hmm, what does the Recordsource to the report show? Is it duplicating?

  6. #6
    AArcher21 is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2018
    Posts
    3
    I’ll sanitize and post it in the morning.

    Quote Originally Posted by June7 View Post
    If you can't provide a copy that is 'sanitized', doubt if I can help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Duplicating a Report Look and feel
    By Bentley in forum Reports
    Replies: 1
    Last Post: 10-13-2016, 01:13 PM
  2. Duplicating Access Report
    By RonelWebb in forum Reports
    Replies: 2
    Last Post: 08-31-2015, 06:53 AM
  3. Report duplicating data
    By tarhim47 in forum Reports
    Replies: 3
    Last Post: 05-03-2011, 08:31 AM
  4. Report duplicating itself many many times
    By TrudyD1474 in forum Reports
    Replies: 1
    Last Post: 06-24-2010, 11:59 AM
  5. Duplicating lines in an invoice report
    By GordonEdinburgh in forum Forms
    Replies: 0
    Last Post: 04-21-2007, 12:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums