Results 1 to 2 of 2
  1. 12-18-2012, 06:22 AM #1
    Newby
    Newby is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    60

    Top X records


    I am looking for a way to query to top 10 or 25 records, and can you do this using a calculated field as the basis for the ranking?
    Reply With Quote Reply With Quote
  2. 12-18-2012, 10:40 AM #2
    NTC
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    the Top X is an embedded feature in the product - you will find it in the ribbon during Query create / design.

    yes this will work with a calculated field.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Appending inventory records with current price records
    By sberti in forum Database Design
    Replies: 8
    Last Post: 11-29-2012, 10:24 PM
  2. find records with related id and search for keywords within records
    By live2ride in forum Access
    Replies: 10
    Last Post: 10-10-2012, 11:15 PM
  3. A query that excludes certain records based on the existence of other records...
    By spsoisson in forum Queries
    Replies: 4
    Last Post: 08-02-2012, 10:59 AM
  4. Access 2007 - Creating New Records Based on Existing Records
    By GeorgeAugustinePhillips in forum Forms
    Replies: 9
    Last Post: 10-05-2011, 05:58 PM
  5. Auto populate new child records based on subform records
    By robsworld78 in forum Forms
    Replies: 12
    Last Post: 08-30-2011, 03:36 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums