To follow-up Calvin's post:

Option A:
  1. Create temp table with autonumber column (either declared as such, or via a trigger that does an "update x = select max(x)")
  2. Select into this table (ideally limiting rows processed to 10 for performance reasons)
  3. Select * from this table

Option B:
  1. create cursor for your select
  2. loop 10 times and fetch from your cursor (either directly to the front-end or into a temp table)
  3. (if required) select * from temp table

Option C:
  1. A specific Access call to limit the number of rows such as Top or TopValues (sorry I don't know more Access)

Good luck,

Robin