Using the TOP clause

[WSlepecki]

Hello,

I am trying to write a query that will select the first say 1000 records from one table into another table. I was successful using the TOP clause when I wanted to hard code the number of records returned. How do I modify the SQL to allow the user to enter the number of records they want instead of having a fixed number? Help!

The code that I currently have is:
SELECT [UNUSED IBM NBRS].ID, [UNUSED IBM NBRS].IBM INTO [IBMs Selected]


FROM [UNUSED IBM NBRS]
WHERE ((([UNUSED IBM NBRS].ID) In (SELECT TOP 1000 ID
FROM [UNUSED IBM NBRS])));

[Rixxe]

You can just change the '1000' to the name of your textbox in which the user will enter a number. If you are using a form or something similar
SELECT [UNUSED IBM NBRS].ID, [UNUSED IBM NBRS].IBM INTO [IBMs Selected]
FROM [UNUSED IBM NBRS]
WHERE ((([UNUSED IBM NBRS].ID) In (SELECT TOP &TextBoxUser& ID
FROM [UNUSED IBM NBRS])));

Now obviously that isnt the right syntax, but google should help with that. Guess is that you will need some VBA, but then i'm really not sure, you might just be able to add the textbox name and run it