I am trying to limit the number of records retrieved from a MS ACCESS 2000 database. When I send it the SQL statement...

SELECT * FROM [table] WHERE [cond] LIMIT 1,10

It doesn't like the LIMIT keyword - does anyone know if Access allows the LIMIT keyword. If not, can anyone suggest another method of limiting a certain range of records?

Thanks in advance!!!

    I wrote an article on sql.battlegeek.com about howto use the TOP clause to perform the same functionality as LIMIT ... using Microsoft Access 2000 and above, and Microsoft SQL Server ... the article is located here:

    http://sql.battlegeek.com/comments.php?aid=50&

    This article was re-posted to phpbuilder.com, but I am unaware of where it is located ... the search does not return any results when I search for exact phrases ... so ... I give you the #SQL on EFNet forum ... 😉

    -- Dave

      Awesome - thanks for the heads up Dave - that was exactly what I was looking for.

        Write a Reply...