To follow-up Calvin's post:
Option A:
- Create temp table with autonumber column (either declared as such, or via a trigger that does an "update x = select max(x)")
- Select into this table (ideally limiting rows processed to 10 for performance reasons)
- Select * from this table
Option B:
- create cursor for your select
- loop 10 times and fetch from your cursor (either directly to the front-end or into a temp table)
- (if required) select * from temp table
Option C:
- 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