Results 1 to 3 of 3
  1. #1
    Faisal Mobin is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    4

    Display top 25 %

    I have a date containing two filed Company name and Sales . I have designed a query Company name and Sales and display the result in ascending order Sales wise. I ave one another requirement which i could not sort out to display the result of top 25 % in the query result

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    This example is from Help:

    SELECT TOP 10 PERCENT FirstName, LastName FROM Students

  3. #3
    Faisal Mobin is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    4
    Thanks it works

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

Similar Threads

  1. display form(s) nothing else.
    By dgamma3 in forum Access
    Replies: 1
    Last Post: 01-20-2012, 09:55 PM
  2. images won't display
    By merlin777 in forum Access
    Replies: 6
    Last Post: 09-02-2011, 09:02 AM
  3. Getting a map to display
    By cggriggs in forum Forms
    Replies: 1
    Last Post: 07-13-2011, 06:43 PM
  4. Report control of a field display/no display
    By systems013 in forum Reports
    Replies: 5
    Last Post: 02-01-2010, 09:44 AM
  5. Display last five records only
    By premdasp in forum Queries
    Replies: 3
    Last Post: 11-18-2009, 11:53 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