Using The Select Top ... Offset In Access ?????

[bfirpo]

ok how can i get the register nº 10 whithout finding in all the registers of the table.?
In mySQL would be: SELECT * FROM mytable LIMIT 1 OFFSET 10
In ORACLE: SELECT * FROM mytable ROWNUM 10

In ACCESS : ........

I can't find by the id because it's not correlative

[PEB]

Hi
Maybe you need:

SELECT TOP 10 * FROM Mytable;

:)