Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameter using multiple options 0
Top 50% Grouped by Month 3
Determine Max Record 1
Update query to set value based on position in recordset 2
Query that can number records on the fly??? 3
need to change Access query results formatting 1
Query which Value Returns Previous Record 8
Pass through query works fast but not as basis for other queries 5

Back
Top