SQL statement to return n records after a time

[Jeff]

Hi

I need to construct a SQL statement to return n records immediately
following a specific date/time, but in descending order by date/time. Using
TOP always gets n records immediately before the maximum date/time,
naturally.

The records have to be in descending order.

Any ideas.

Jeff

[Steve Jorgensen]

You just need a query of a query. Save the Top Values query, make another
query using the first query as a source, and sort it however you like.

On Mon, 19 Jul 2004 05:59:51 GMT, "Jeff" <je************@asken.com.au> wrote:

Hi

I need to construct a SQL statement to return n records immediately
following a specific date/time, but in descending order by date/time. Using
TOP always gets n records immediately before the maximum date/time,
naturally.

The records have to be in descending order.

Any ideas.

Jeff