Help me in selecting first n records from a table by SELECT Query

[khursheed]

Dears

1- I want to make a query to select first n records from a table. The table has no field like autonumber.

2- How can I use a variable in query. for example

n=100 n is a variable

SELECT * FROM table WHERE numericfield>n

[ADezii]

Dears

1- I want to make a query to select first n records from a table. The table has no field like autonumber.

2- How can I use a variable in query. for example

n=100 n is a variable

SELECT * FROM table WHERE numericfield>n

SQL to Select the first n Employees (ALL Fields):

Dim n As Integer
 
n = 100
 
SQL ==>  "SELECT TOP " & n & " Employees.* FROM Employees;"

[khursheed]

SQL to Select the first n Employees (ALL Fields):

Dim n As Integer
 
n = 100
 
SQL ==>  "SELECT TOP " & n & " Employees.* FROM Employees;"

Thanks a lot for helping me.

[ADezii]

Thanks a lot for helping me.

You are quite welcome.