select range of records

[prodigy]

Is there a statement that will allow me to select a range of records in the
middle of a selection of records? e.g. Rather than TOP 10, can I get like
records 10-20, or 50-65 etc?
Prodigy.

 

[iago18]

Something like this:

SELECT Table.Field1 FROM Table WHERE Table.FieldID > 9 AND Table.FieldID < 21;

That should select only those records with IDs between 10-20.

 

[prodigy]

Hello iago18,
Nice to hear from u. Thanks for trying to help me with the issue. However, if you see my posting u would find that am NOT looking for records between FieldID 9 and 21. Am looking for something thats similar to the (TOP 10 select statement) ie it will display not the TOP records but my selected range. I wont like to specify according to the ID value as the Table should have ID as one of the columns.
Prodigy.

 

[iago18]

I don't follow you...

What criteria are you using to decide what the "first" record is and the "last" record? If you have a unique key (hopefully an autonumber) then my suggestion will work fine. If not, then I don't know how to help. There is no SQL statement for "SELECT TOP <WHATEVER I FEEL LIKE>" that I am aware of. I'd suggesting adding an autonumber primary key (which every relational table should have) and then filtering by that ID as I suggested above.

If I'm still missing the point, I apologize.

 

[mresann]

I think I get his point. First, let's assume a query that returns records sorted on a unique field to prevent possible duplicates. He wants to return a specific number of records starting from a record number that is in a specific location of a sorted query. For instance, "TOP 10" would return only the top 10 records. In pseudo code, let's replace "TOP 10" with "1 THROUGH 10". He wants to return the records from a specific place in the query, say, record 11, and return 10 records in total, so the pseudo code would be "11 THROUGH 20".

Is that the right track? What you would need is to find a numbering query, or a query that creates a field that shows a counting number, ie the top record in the sort order would reflect a value of 1, the second record 2, and so on. Then your query condition would show the range in the Condition box. If you wanted 10 records starting at record 11, then the condition box of the counting field would show ">=11 and <=20" or something similar to that.

Hope that helps. If you need an autonumbering query, search the forum.

 

[prodigy]

Hi mresann/iago18,
Recvd ur reply. Good to know that mresann understood my problem and tried best to help me. Thanx...
As suggested by u, I have searched autonumbering query in the forum but of no help. Could u get me the resolution. Thanks again in advance.
Prodigy.