Query

J

JDinLR

I'm trying to write a query that will return a specific sequence inside a
record set.. example: return records 20 to 50
Thanks!!! JD
 
S

Sprinks

JDinLR,

If the numbers 20 to 50 are in a field in your table, use the between
operator in the Criteria row of the query:

Between 20 And 50

Hope that helps.
Sprinks
 
J

John Vinson

I'm trying to write a query that will return a specific sequence inside a
record set.. example: return records 20 to 50
Thanks!!! JD
Click to expand...

Unless you have your own record number field as a data field within
the table, you cannot do this. A relational table is an unordered
"heap" of data - you can't return records numbered 20 to 50, any more
than you can pick out minnows number 20 through 50 from a bait bucket!

If you have a number field (autonumber or other, though an Autonumber
would be a bad choice as it cannot be edited and will always have
gaps) you can use a criterion of

BETWEEN 20 AND 50

on a Query.

John W. Vinson[MVP]
 
Top