Results 1 to 3 of 3

Thread: SQL in Access

  1. #1
    Join Date
    Mar 2004

    Unanswered: SQL in Access

    Hi i have been tryin to find a way in Access to make a query only return specified rows of the table, i have found how to do this for a specified number from the top using SELECT TOP 3 *, but i need to make it work for say rows 5-10. Some one gave me this statement to try but it doesnt seem to be working.
    SELECT * FROM [stored by SAT scores] LIMIT 5,10
    where [stored by SAT scores] is the query where i want to get the rows from. Any help would be great. Im real new to SQL so not too complicated please, thanks Mark

  2. #2
    Join Date
    Dec 2001

    Re: SQL in Access

    You need records 5 thru 10? If they don't have some criteria thatyou can use to select them, then try taking the top 10, then sort the resulting records in reverse order and take the top 5.

    Hope this helps,
    Peter De Baets
    Peter's Software - Microsoft Access Tools for Developers

  3. #3
    Join Date
    Jan 2004

    Re: SQL in Access

    You can add an autonumber field to your table which will number all the records in the order they are presently (if you want a different order do another select statement with a different order criteria i.e. SELECt * INTO TABLE2 FROM TABLE1 Order BY...").

    Then using the new field select the records that you want.
    In abundance of water only the fool is thirsty. Bob Marley.

Posting Permissions

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