Selecting Records

  • Thread starter Thread starter LJ
  • Start date Start date
L

LJ

Is there a way to select a range of records in an Access Query? For example,
if I have over 180,000 records, how do I select records 55,000 to 65,000 in
order to copy and paste to an excel worksheet?

Thanks!
 
you enter the first record number in the searh box at the bottom. Select
that record then enter last record number, hold down shift key and select
it. Then Copy and go to excel and paste. Or were you looking for something
more automated. A little more info may get a better answer.
 
Well, for starters, there are no record numbers in Access. If you are
talking about the number you see in form or datasheet view that shows a
number for the current record, that is known as the Absolute Position
property of a recordset. It is not a static value. It only says "This is
record 96 of 324" If you add a record, delete a record, or resort the
output, record 96 will be a totally different record.

So the short answer is - Not really.
But, if there is some logic to which records are to be selected, then you
can sort the records in the query and use the TOP predicate to return a
specific (sort of) number of records. I say Sort Of because if you say TOP
10 and there are ties in the Where clause, you might get more than 10 records.
 
Back
Top