Nth select records in the table

[Nick999]

Hello,

I need help, I have a table with 13450 records, i need to nth select down to 10,000 records, how do i go about doing this using ms Access/VBA

[Seth Schrock]

Not exactly sure what you are wanting, but you can select the top x number of records. You would just set your ORDER BY clause to sort the records the way you want and then use

SELECT TOP 10000 fields
FROM table_name
ORDER BY Your_sort_order

[twinnyfo]

Or.....

If you want records N through 10,000, then after running Seth's query, and first determining what N is, calculate 10,000 - N:

    Dim intValue As Integer
    Dim strSQL As String
 
    intValue = 10000 - N 'This is just the concept
    strSQL = "SELECT TOP " & intValue & " fields " & _
        "FROM qrySethByQuery " & _
        "ORDER BY Your_sort_order DESC;"

Notice how I switched the sort order.

Hope this hepps!