In SQL Server, we use this sQL for set rowcount : SET ROWCOUNT @top or select top (@top) * from Table How to use this query in MS Access SQL?

Reputation:

Select TOP N not working in MS Access with parameter

In SQL Server, we use this sQL for set rowcount:

SET ROWCOUNT @top

select top (@top) * from Table

How to use this query in MS Access SQL?

Upvotes: 2

Reputation: 97100

Access does not support using a parameter for SELECT TOP. You must write a literal value into the text of the SQL statement.

Upvotes: 3