Split table in 4 equivalent parts by 3 criteria

[iordache09]

Hi all,


I have a table with the folowing structure:

ID(integer)	Value1(Double)	Value2(Double)

I need to split this table in 4 equals parts:
- count of id must be equal or close to equal(ex: 467 split in 3 x 117 and 116) for each part
- the cumulated Value1 and Value2 must be equal or close to equal for each part

Can u please help with a solution

Thx

[orange]

When you cross post -- post same question on several forums -- please tell the reader you have done so.

Cross posted: http://www.access-programmers.co.uk/...d.php?t=272661

[iordache09]

Sorry, I thought that i can't post link, because i'am new on forum.

Thanks

[orange]

Perhaps not, but you could tell people you have posted on other site(s) even without the link.

Here is why readers want you to inform them of the cross post.