Member Avatar for werks

Hi there. how can i limit the value of records in Access. Is there a LIMIT function in Access like in MySQL? tnx in advance..

  • 3 Contributors
  • 4 Replies
  • 120 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by wellsantos

Recommended Answers

All 4 Replies

Member Avatar for hollystyles

select TOP 10 somecolumn FROM blah...

Member Avatar for werks

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

Member Avatar for hollystyles

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.

Member Avatar for wellsantos

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 because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.