Prob with SQL where statement

[lizray]

I have a recordset with one of the fields, "nbr" containing numbers that increase in value, but are not contiguous. I want to select records based on this field, and specifying the starting value and the next 10 records. If for example I wanted to get records starting with nbr=14, the where condition could be "between 14 and ???? How do I specify the upper limit. I would really appreciate some help !

 

[Andrzejek]

[tt]
Select TOP 10 ..., ...
FROM SomeTable
WHERE nbr >= 14
[/tt]

Have fun.

---- Andy

 

[PHV]

SELECT TOP 10 ... WHERE nbr>=14 ORDER BY nbr

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lizray]

Thanks for that. My experience in this area is limited and I appreciated your help. It solved the prob.