Getting bottom N records from table (as opposed to TOP N)

[VMI]

How can I get the bottom N records from an Access table?
For example, if I want to display records 151-200 (with ID as PK), my query
would be:

"select top 50 * from audit where ID > 150 order by ID asc"

Since ID is type AutoNumber, I'll see records 151-200. But once I'm
displaying them, how can I go back to seeing 101-150? I tried:

"select top 50 * from audit where ID <= 150 order by ID desc" and it'll show
me the correct data, but from 150-101.

Thanks.

 

[Craig Alexander Morrison]

Use a query and Sort Descending on the relevant field.

 

[VMI]

How do you mean?
It's already sorted by descending.

 

[Rick Brandt]

How do you mean?
It's already sorted by descending.

A TOP query sorted one way is identical to a BOTTOM query sorted the
opposite way. Since there is no BOTTOM clause available, you have to
reverse the sort and use TOP.

 

[VMI]

That's what I do:

select top 50 * from audit where ID > 150 order by ID desc

but I get an incorrect result. I get the last 50 records of the table .

 

[Rick Brandt]

That's what I do:

select top 50 * from audit where ID > 150 order by ID desc

but I get an incorrect result. I get the last 50 records of the table .

If newer records have a higher ID (usually the case) then if you sort the
IDs in descending order the newest ones will be at the top. If that's not
what you want then sort Ascending on ID. One of them should be what you
want.

 

[Craig Alexander Morrison]

Then sort it ascending, doh!