I want the first X records of my recordset

[Nirious]

How do I do this.
I need to get the first say 15 records of my table, actually a recordset from a form. And I want to put them into a new table with the same structure as the original (I can make this in advance so it doesn't have to be in code). Than I want all the other records, 16 and more to be added to a third table. Also with the same structure.

Any idea how to pull this off?

 

[Rich]

The question has to be Why?

 

[Nirious]

Because I can only print 15 records on my paper. thus when there are more than 15, I will need to put the rest on a second page.

So please if you know how to do it, don't ask why and just tell me

Thx

 

[Rich]

I asked why because there didn't appear to be a good reason for wanting to create tables like this. Having read your answer I now see that I was right to ask why.

You don't need separate tables to produce lengthy reports, if the underlying query has 500 records your Report will print them.

Have a look at the Northwind sample db that ships with Access to see how Reports are constructed.
Post back if you have further questions

 

[Nirious]

yes, I think I get it now

But I still have a problem. But I will post about it in the report forum.