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
 
Back
Top