extract by record number?

[wjl11]

Hello,
I would like to extract records from an mdb by record number. IE: record#s 80000-82000.
Whats the easiest way to do this?
Thanks,
Will

 

[dodge20]

select * from table
where id between '80000' and '82000'

or

Select * from table
where id between [Enter Begin Id] and [Enter End Id]

Dodge20

 

[wjl11]

Thanks Dodge,
There is no ID# (key) on this table, so I need to use the actual record numbers. Any idea how I do that?
Will

 

[dodge20]

I don't know of a way. What I would do, is add an autonumber field that numbers each of the records. Then you can run the above query using your new column, in place of id.

Dodge20