Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello. (Access 2003)

    In a Totals query there is a First option. How can I create a query to pick the first and second items?

    Thanks, Andy.

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Take a look at the SQL function of TOP.

    Something like the following

    SELECT TOP 2 Grade_report.STUDENT_NUMBER, Grade_report.SECTION_ID, Grade_report.GRADE
    FROM Grade_report
    ORDER BY Grade_report.GRADE;

Posting Permissions

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