Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2015
    Posts
    10

    Answered: Last N rows Query

    Hi All,

    I am trying to build a sports database in MS Access and I would like to make a query that will retrieve the last 6 games of a team (in and out).
    The table has as records the DATE, HOME team, AWAY team & the Score. Can anybody helps with the syntax of the query?

    Many thanks

  2. Best Answer
    Posted by healdem

    "Use the SELECT TOPkey word and set an ORDER BY clause so you get the right n rows"


  3. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Use the SELECT TOPkey word and set an ORDER BY clause so you get the right n rows
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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