Results 1 to 4 of 4
  1. #1
    aksnell is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    4

    Limit number of records in report

    I have 2 tables, the first with general information, and the second is a "notes" table. The tables are joined by a one to many relationship, one record in the general table, and infinite number of records in the notes table. I am creating a report and I want to have specific fields from the general information table, but only the 2 most recent notes from the notes table. Is that possible?

    Thank you!
    Amy

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Either the TOP predicate on its own or:

    ACC: How to Create a Top N Values per Group Query
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    aksnell is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    4
    Thanks for your help. Unfortunately, the article you posted did not help me. The first solution was not really pertinent, and the 2nd solution uses visual basic which I do not have, nor do I know how to use. Any other suggestions? Can I build a macro? Thanks for any advice.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Did you try the TOP predicate alone?

    SELECT TOP 2 Field1, Field2
    FROM TableName
    ORDER BY FieldName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Counting No of records above the limit.
    By cap.zadi in forum Reports
    Replies: 5
    Last Post: 11-29-2011, 12:51 PM
  2. Replies: 5
    Last Post: 12-26-2010, 10:56 PM
  3. Replies: 7
    Last Post: 07-22-2010, 01:14 PM
  4. Limit number of records in report by group
    By Dr Ennui in forum Reports
    Replies: 0
    Last Post: 06-22-2010, 12:36 AM
  5. Limit Records
    By EHittner in forum Forms
    Replies: 1
    Last Post: 05-03-2010, 10:37 AM

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