Paging and Sorting wtih Access Query

[Carlos Durán Urenda]

Hi

Who I Can do it

with the SQL Sentence ...
SELECT TOP 50 FROM Table ORDER BY Id
I get First 50 rows from a table

with Sentence ...
SELECT TOP 50 FROM Table WHERE Id > LastRowId ORDER BY Id
I get the next 50 rows from a table

But. if i want order by another field, who can i get the next resultset?

Tnks
CD

 

[[MVP] S.Clark]

SELECT TOP 50 OtherFieldName, ID FROM Table ORDER BY OtherFieldName, ID ??

 

[Carlos Durán Urenda]

tnks

SELECT TOP 50 OtherFieldName, ID FROM Table ORDER BY OtherFieldName, ID ??