Results 1 to 5 of 5
  1. 06-14-2011, 06:39 AM #1
    rici7
    rici7 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    6

    First x records in query


    I have created query which contains about 140 records. Can anybody tell me how to display in this query only first 50 records?
    Reply With Quote Reply With Quote
  2. 06-14-2011, 07:25 AM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Show us the query.
    Reply With Quote Reply With Quote
  3. 06-14-2011, 12:55 PM #3
    Rhino373
    Rhino373 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    65
    Use Top N. So your query would look like SELECT TOP 50 fieldname....... Change to SQL view to be able to type this in.
    Reply With Quote Reply With Quote
  4. 06-15-2011, 04:03 AM #4
    rici7
    rici7 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    6
    Here is an example. Can you please show me how to display only first 3 records?
    Reply With Quote Reply With Quote
  5. 06-15-2011, 06:43 AM #5
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    rici7,
    I don't have acc2007 and can not open a file accdb.

    The syntax is

    SELECT TOP 3 * FROM PutYourTableNameHere
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Date function to query records and Sum records
    By sullynivek in forum Queries
    Replies: 0
    Last Post: 04-05-2011, 08:37 AM
  2. Can't get all records in query
    By salisbut in forum Queries
    Replies: 2
    Last Post: 08-12-2010, 10:00 AM
  3. Return all records from Query
    By ysrini in forum Queries
    Replies: 1
    Last Post: 01-15-2010, 09:52 PM
  4. Find Records Query
    By sullyman in forum Programming
    Replies: 1
    Last Post: 10-28-2009, 08:49 AM
  5. How to Add New Records based upon Query?
    By SteveAb in forum Database Design
    Replies: 0
    Last Post: 08-06-2009, 10:24 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