Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Database Management
Reload this Page

Limit for Access 2000

Discuss Limit for Access 2000 in the Database Management forum on Dev Shed.
Limit for Access 2000 Database Management forum discussing non-database specific SQL. Structured Query Language was designed to be a robust and standardized language for manipulating relational databases.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old October 9th, 2003, 01:37 AM
jjoske jjoske is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2001
Posts: 286 jjoske User rank is Lance Corporal (50 - 100 Reputation Level)jjoske User rank is Lance Corporal (50 - 100 Reputation Level)jjoske User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 3 Days 5 h 24 m 46 sec
Reputation Power: 7
Limit for Access 2000
I'm doing a small project in Access 2000, and it doesn't seem to understand the LIMIT statement. ie

SELECT * FROM table LIMIT 10 OFFSET 10

Can anyone tell me what the syntax is for LIMIT in access?
Reply With Quote
  #2  
Old October 9th, 2003, 12:35 PM
binky's Avatar
binky binky is offline
Gerbil
Dev Shed Intermediate (1500 - 1999 posts)
  
Join Date: Oct 2001
Location: In a Rotastak
Posts: 1,763 binky User rank is Sergeant (500 - 2000 Reputation Level)binky User rank is Sergeant (500 - 2000 Reputation Level)binky User rank is Sergeant (500 - 2000 Reputation Level)binky User rank is Sergeant (500 - 2000 Reputation Level)binky User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 22 h 12 m 52 sec
Reputation Power: 18
Don't think it does.... but you could simply cycle through the returned recordset using a variable as a loop counter and disregard the records that you don't want. Then break the loop after the upper limit.
__________________
- Sorted!

www.ppfuk.com - Free Photo Sharing
Reply With Quote
  #3  
Old October 9th, 2003, 12:58 PM
Doug G Doug G is offline
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
  
Join Date: Jun 2003
Posts: 10,957 Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 1 Day 15 h 33 m 54 sec
Reputation Power: 802
LIMIT isn't in Access SQL.

If you open the Access help file contents, there is a chapter on Access SQL that describes the SQL commands available.
Reply With Quote
  #4  
Old October 9th, 2003, 05:41 PM
jjoske jjoske is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2001
Posts: 286 jjoske User rank is Lance Corporal (50 - 100 Reputation Level)jjoske User rank is Lance Corporal (50 - 100 Reputation Level)jjoske User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 3 Days 5 h 24 m 46 sec
Reputation Power: 7
I ended up using SELECT TOP recordNo and then cycled until the last record. If I get time I will have a look to see if I can find a better solution.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Database Management > Limit for Access 2000

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway.