selecting a certain number of records

[Crazy D]

Assuming that you have some sort of ID in the database,
recordset.Open "SELECT * FROM MyTable WHERE ID > 300 AND ID < 600 ORDER BY ID"