3
Contributors
4
Replies
5
Views
9 Years
Discussion Span
Last Post by wellsantos
0

tnx hollystyle.. Is it possible to get the remaining results in the query after using the TOP?

e.g.

Select TOP 10 qryOPAC.* FROM qryOPAC

It returns 20 records, since im using the TOP 10 it will only return the first 10 records, right? Now how about the remaining 10 records what happen to them?


Kenneth

0

what are you trying to do. Page the data? I don't follow what you want.

TOP just stops after the limit is reached, that's it. AFAIK that'a all LIMIT does in MySql as well.

0

In mysql I do:

select * from tbl limit 10,20;

So, I can retrieve from 10º until the 30º reg

How can I do it using ms access?
I need it for paging :icon_cheesygrin:

Thanks

Edited by wellsantos: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.