Results 1 to 3 of 3

Thread: [RESOLVED] Access report: only show the first xx number of records

  1. Feb 21st, 2007, 10:53 AM #1
    Redmar
    Redmar is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2006
    Posts
    16

    Resolved [RESOLVED] Access report: only show the first xx number of records

    I have a very simple issue, so maybe it is also very easy to solve, but I could not find a way to solve it...

    I have a report that displays lets say a few hundred records. I have sorted the records on a specific field and now I want to display only the first 15 records.

    Is there a method to stop displaying the records after the 15th record is displayed?
    Last edited by Redmar; Feb 22nd, 2007 at 03:49 AM. Reason: Resolved
    Reply With Quote Reply With Quote
  2. Feb 21st, 2007, 03:22 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Access report: only show the first xx number of records

    Is your report based on a query? If yes it could include the Top clause.

    Select Top 15 ...
    Reply With Quote Reply With Quote
  3. Feb 22nd, 2007, 03:47 AM #3
    Redmar
    Redmar is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2006
    Posts
    16

    Re: Access report: only show the first xx number of records

    Thanks, that was exactly what I was looking for! I didn't know about the Top clause before. A handy one!
    Reply With Quote Reply With Quote
« Previous Thread | Next 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


Click Here to Expand Forum to Full Width