Split Resordest

[DMT Dave]

Hi all, a bit of a long shot but if this is achievable, splitting a recordset into 2 recordsets if the 1st recordset has a count over 24 lets say rs1 and rs2

If rs1 count has got ie: 36 records, can i split the 1st 24 records of rs1 and update excel sheet1 and set the remainder of the records 25 to 36 to rs2 then onto Excel sheet2 ??



Reason being, I can border a excel template and set to print 1 page wide by 1 page tall on each sheet

Thank you all

[isladogs]

You could use SELECT TOP 24 … and an unmatched query based on that against all records for the rest.
But what if there are more than 48?

[CJ_London]

why do you need to do that? - why not just format the excel printer to print a range where a page is 24 rows high? presumably you need headers as well?

[DMT Dave]

Hi Colin, thank for your reply, 48 to 72 goes onto worksheet 3

Kindest

[isladogs]

Can you see why I asked about >48?
I think you need a different solution such as that suggested by Ajax.