Results 1 to 3 of 3
  1. #1
    stephenvought is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Aug 2018
    Posts
    5

    Smile Limiting a report to only 10 results, but not limiting the query

    Hello!!

    This is my first thread for any Access forum, and I'm not much of a database guy, sooo.....

    Initial Conditions:



    Query that pulls data - including a field called [Facility] - from several tables.
    A report that is generated using "Click()" in my main menu. The code passes the [Facility] by way of an "i" value in an array of facilities. The report opens, does its thing, saves a PDF, closes the report, then goes to the next "i".

    Desired Result:

    Without limiting the query to only 10 results, I would like to stop the report at 10 results, using the "=1" text box value when it hits 10.

    I've tried a lot of different paths, but the report still runs all results for each report, which can be 100+.

    Thanks in advance!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I don't know a way to use the calculated running sum to prevent display of records. Probably will have to apply filter criteria to the report. Perhaps determine range of the record ID's.
    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
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Without limiting the query to only 10 results, I would like to stop the report at 10 results
    what is the rationale for doing this? Can't see why you wouldn't be able to use SELECT TOP 10...

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

Similar Threads

  1. Need help on left join and limiting results
    By scott0_1 in forum Queries
    Replies: 7
    Last Post: 06-14-2018, 04:29 PM
  2. LIMITING Query results from multiple tables
    By moneypennie21 in forum Queries
    Replies: 8
    Last Post: 07-18-2017, 06:36 AM
  3. Replies: 24
    Last Post: 04-08-2015, 02:59 PM
  4. Limiting Query Results to Unique Values
    By orangeman2003 in forum Queries
    Replies: 2
    Last Post: 12-25-2013, 01:08 PM
  5. Limiting the results displayed in a report
    By musicalogist in forum Reports
    Replies: 1
    Last Post: 06-10-2010, 04:44 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