LIMIT in MSAccess SQL Query
-
Hi All, How can I get records for a limit in MS Access. Let say, there are 2500 records are in table. I want to fetch records from 1800 to 1900... TOP clause coould not solve this problem.... Thanks in advance... Suman Singh
-
Hi All, How can I get records for a limit in MS Access. Let say, there are 2500 records are in table. I want to fetch records from 1800 to 1900... TOP clause coould not solve this problem.... Thanks in advance... Suman Singh
-
Hi All, How can I get records for a limit in MS Access. Let say, there are 2500 records are in table. I want to fetch records from 1800 to 1900... TOP clause coould not solve this problem.... Thanks in advance... Suman Singh
Access does not have a function that selects a range of records like MySQL, You will have to calculate this programmatically. You can use several methods. I would suggest the double SELECT TOP with reversed ordering.
Excellence is not an act, but a habit!
Aristotle