Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    65

    Unanswered: Limiting Records Displayed

    How can I limit the records selected in a query by a specific number? I need to do a meil merge from Access to Word but I only need it to print 20 or so records. The database contains 4,000 records. What I need is a query that will limit it to the number I specified. Is this possible?

  2. #2
    Join Date
    Oct 2003
    Posts
    16

    Re: Limiting Records Displayed

    On the query's Properties page change the Top Values field to the number of records you want returned.

    Originally posted by Jigsatics
    How can I limit the records selected in a query by a specific number? I need to do a meil merge from Access to Word but I only need it to print 20 or so records. The database contains 4,000 records. What I need is a query that will limit it to the number I specified. Is this possible?

  3. #3
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    65
    where can I find the Properties page of the query?

  4. #4
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile

    Originally posted by Jigsatics
    where can I find the Properties page of the query?
    Right click in the main query window and choose properties. Not in the grid with the chosen fields in it.

    Gregg

Posting Permissions

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