Create table query issue

[hollarindy]

Hello All,

I have run into hurtle on a project I am working. I am trying to create a query that will make a new table with the next 10 records from another table.

let me back up. I have query A that creates table A which is a randomized version of two other combined tables A1 and A2. Then I have query B which creates table B that only shows me the first 20 entries from table A. I need to create query C which will give me entries 21-30 from table A. Any suggestions that don't involve VBA would be greatly appriciated. I don't mind VBA I'm just not entirly sure how I would incorporate it at this point.

 

[plog]

Lots of things smell wrong with this. First, making tables is generally a sign of a poor process or structure. Second, order terms ('first', 'next', 'last', etc.) never apply to tables--they have no order so saying first, last, or 34th record is meaningless when talking about tables.

So, lets start from scratch. Please provide a sample of what data you are starting with, and then what data you want to end up with.

 

[hollarindy]

Got it to do what I needed.

SELECT TOP 20 AccyAll.ID1, AccyAll.ID, AccyAll.[Part Number], AccyAll.Noun, AccyAll.Name, AccyAll.DLC, AccyAll.DDC, AccyAll.JCN, AccyAll.[Serial Number], AccyAll.Int, AccyAll.Auth, AccyAll.Status INTO tblRandom
FROM AccyAll
ORDER BY Rnd([ID1]);