title: Access 'select rows between' query
body: <p>I have a basic query in access. The SQLlooks like:</p>
  
  <pre><code>SELECT tblAssignedWords.ChildID, tblAssignedWords.Child, tblAssignedWords.WordID, tblAssignedWords.Word, tblAssignedWords.Status, tblAssignedWords.WordDifficulty, tblAssignedWords.WeekNumber
  FROM tblAssignedWords
  WHERE (((tblAssignedWords.ChildID)=1));
  </code></pre>
  
  <p>This pulls through 70 records. I only want to see records on rows between 10 and 20 (10 records in total). Is there and SQL statement i can use to see only these rows?</p>
  
  <p>Thanks</p>
  
  <p>Craig</p>