Divide table into two parts

Hi all!

I wanna divide a table into two parts by inserting a page break after a certain row (I need only one page break). How can I achieve this goal?

Thanks.

What do you mean by page break, do you mean that the first part stays in the table and the other part goes to another table ? Which is the ORDER criteria that you want these tables to order for ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||I've got several controls just after table and i need that controls are displaied at the same page as table (at least a row must be at the same page with controls). At the moment I can get a situation when table is displaied in one page and controls are dispaied on another page.