Getting 2nd row in a table

[Laurel]

I need to get the 2nd row in a table, when it is ordered by date. I know I
can get it by retrieving the whole result set ordered by date and then step
to the 2nd row in the recordset. But that seems inefficient. In some
environments, I believe I've seen a SELECT TOP 10.... or something to that
effect.

1 - Is there such a statement in Access SQL?
2 - Where can I find the syntax for access SQL? I haven't had look using
Access HELP.

 

[Cheryl Fischer]

Laurel,

1 - Is there such a statement in Access SQL?

Yes, it is the "Top Values Property"

2 - Where can I find the syntax for access SQL? I haven't had look using
Access HELP.

You can search in VB Help on Top Values.

 

[Guest]

You may want to chec
http://www.devguru.com/Technologies/sqlsyntax/quickref/sql_syntax_intro.html
Which talks about Transact-SQL for SQL server.
or
http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.htm
Which talks about JetSQL developed for MS Acces

Hope that helps
Harry