SQL Keyword LIMIT in Access

[Tommy408]

Is there a keyword for Access SQL like LIMIT? I need to select ONE specific record in a table. Like the 2nd record or 3rd record independent from ID primary key because I don't know what they are.

 

[CaptainD]

You can use something like this in SQL, not sure about Access:

"SELECT Top 1(cPurchasePrice) From SomeTable Where (cPurchasePrice NOT IN(SELECT TOP 1 (cPurchasePrice)FROM SomeTable))"

 

[TheAceMan1]

How are ya Tommy408 . . .

In [blue]Jet SQL[/blue] no. Perhaps is relates to another [blue]keyword[/blue] in Jet!

What are you intending to limit?

See Ya! . . . . . .