Equivalent to OFFSET clause in Access

  • Thread starter Thread starter plk
  • Start date Start date
P

plk

What`s the equivalent to OFFSET clause (PostgreSQL) in Access? Example:
"SELECT * FROM table WHERE field = 10 ORDER BY field OFFSET 10" will
start at row 10 of the table...
 
Hi,


Unlikely, since a table is not a recordset and has no "record position"
to refer to. If your records are "logically" ordered among themselves
through a field, like a POnumber, add a WHERE clause:

WHERE field = 10 AND PONumber >10


as example.


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Typed text appears in wrong cell 0
What's the Access equivalent for this SQL Server query? 12
Select to reference an other record or row 1
not in criteria fails 2
Split data in field on character return 0
Concatenate with ORDER BY clause 2
Order By clause 4
Single WHERE and ORDER clause in UNION? 4

Back
Top