Results 1 to 4 of 4
  1. 11-10-2023, 07:12 AM #1
    Libin7963
    Libin7963 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2023
    Posts
    1

    Need help please, Access report repeating to multiple pages

    I have put together a report in access and it is a summary of count from the query result but the table is repeating 100s of pages as you can see in the picture. Can anyone please let me know how to make it to only one page.



    Click image for larger version.  Name: Libin7963_1-1699620298610.png  Views: 15  Size: 15.3 KB  ID: 51014
    Reply With Quote Reply With Quote
  2. 11-10-2023, 09:12 AM #2
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    in the query properties: UNIQUE VALUES = TRUE


    or if the data is all in 1 record then: TOP VALUES = 1
    Reply With Quote Reply With Quote
  3. 11-10-2023, 09:38 AM #3
    mike60smart
    mike60smart is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    Hi
    Can you upload the database?
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description
    Reply With Quote Reply With Quote
  4. 11-10-2023, 10:20 AM #4
    xps35's Avatar
    xps35
    xps35 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    232
    Crossposted here https://techcommunity.microsoft.com/...s/td-p/3978322
    Groeten,

    Peter
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Report Indicates Multiple Pages
    By stevebp in forum Reports
    Replies: 5
    Last Post: 03-18-2020, 03:56 PM
  2. Report Repeating Extra Duplicate Pages
    By KMulvey in forum Reports
    Replies: 7
    Last Post: 11-25-2019, 07:08 AM
  3. printing multiple copies of report with multiple pages
    By mhall in forum Reports
    Replies: 9
    Last Post: 08-26-2014, 10:43 AM
  4. Report Generates Multiple Identical Pages
    By astrolabe262 in forum Reports
    Replies: 1
    Last Post: 02-22-2013, 01:29 PM
  5. Report Sent as HTML Body - multiple pages
    By chris.williams in forum Reports
    Replies: 3
    Last Post: 09-15-2012, 07:18 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums