vb Select * from tableA?How to select record from 1000 to 2500
I would try one of the following.
One way I can think of is to select the top 15,000 in query a
Then use query A as source for query b and reverse the sort critieria and select
the top 5000.
Might be pretty slow.
Another way MIGHT be to use a subquery. UNTESTED SQL - I have no idea if this
will actually work.
SELECT Top 5000 FieldOne
FROM TABLE A
WHERE TableA.FieldOne in
(SELECT Top 15000 Z.FieldOne From TableA as Z ORDER By Z.FieldOne Asc)
ORDER BY TableA.FieldOne Desc
Quote:
> Select the Top 15000, then Delete the top 10000 from it.
> That will leave you with the top 10001 to 15000.
> --
> HTH,
> Steve Clark, MVP
> FMS, Inc.
> ---
> See the new Access SpellChecker!
> www.fmsinc.com/products/speller
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > I am trying to use VB program a query
> > select * from tableA where remark is not null,
> > how do I select the (not null remark) record from 10,000 to 15,000 .
> > like I can select TOP 10000 * from tableA
> > anybody can help please post a message here for other reference and also
> > thank you
