Are you using MS Access? If so, I do not think you can limit the query in the same way. You may be able to, but I have never come across it.
You can, however, use the TOP clause.
SELECT TOP 10 * FROM TableName ORDER BY TableNameID;
If you're using MS SQL, you may be able to use a CASE or similar conditional statement to begin ordering at a certain point. See: http://www.siteexperts.com/forums/viewConverse.asp?d_id=17279&Sort=0