•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 375,236 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,021 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 672 | Replies: 3 | Solved
 |
•
•
Join Date: Jan 2008
Location: Philippines, Zamboanga City
Posts: 57
Reputation: 
Rep Power: 1
Solved Threads: 1
Junior Poster in Training
How do i LIMIT in Access 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..
Kenneth
"Better Than Yesterday"
"Better Than Yesterday"
•
•
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,161
Reputation:
Rep Power: 7
Solved Threads: 58
select TOP 10 somecolumn FROM blah...
•
•
Join Date: Jan 2008
Location: Philippines, Zamboanga City
Posts: 57
Reputation:
Rep Power: 1
Solved Threads: 1
Junior Poster in Training
tnx hollystyle.. Is it possible to get the remaining results in the query after using the TOP?
e.g.
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
e.g.
Select TOP 10 qryOPAC.* FROM qryOPAC
Kenneth
Kenneth
"Better Than Yesterday"
"Better Than Yesterday"
•
•
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,161
Reputation:
Rep Power: 7
Solved Threads: 58
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.
TOP just stops after the limit is reached, that's it. AFAIK that'a all LIMIT does in MySql as well.
Last edited by hollystyles : Feb 11th, 2008 at 11:06 am.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
- VB 6.0. Creating a file for random access (Visual Basic 4 / 5 / 6)
- Maximum no. of tables in MS Access Database ? (Visual Basic 4 / 5 / 6)
- 10000 limit on Access 2000? (MS Access and FileMaker Pro)
- Database design (Database Design)
- Ms Access Help Please (MySQL)
- Giving records in MS Access unique numbers (MS Access and FileMaker Pro)
- Can't access to remote computer (Windows NT / 2000 / XP / 2003)
- visual c++ strange compile error... (C++)
- .htaccess not working.! (Linux Servers and Apache)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Hi...am new
- Next Thread: Storing matrix into MS Access!!!
