Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Victoria, BC
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Limiting rows returned (Access2002 SP3)

    What can I do to limit the number of rows returned in a query/report to say, 5?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Limiting rows returned (Access2002 SP3)

    If the report is based on the query, then limiting the query will od it for the report.
    So for the query what lines do you want?

    If you set criteria, then you will return the rows that match the criteria.

    Alternatively, in the query grid you can limit the query to the top number or percentage of rows as shown in the picture below.
    Regards
    John



Posting Permissions

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