I have a table with more than 5000 rows. I want split this data into a batch (20 per batch) based on two criteria columns TEAM_ID and TEAM_CATEGORY.
For example if a batch has 45 members then it should split as 20+20+5.
I have a table with more than 5000 rows. I want split this data into a batch (20 per batch) based on two criteria columns TEAM_ID and TEAM_CATEGORY.
For example if a batch has 45 members then it should split as 20+20+5.
Where does the result of the split reside? How to differentiate one split from another? Example data required with end result shown.
Why won't the new table look just like the old table? Again, what will differentiate the splits from each other and from the original?
Without this information, we're at a dead end.
Have you considered just trying a report that is sized to print exactly 20 records per page and to force a page break after each group? Well, I guess 5000 records would be a rather lengthy report.
Otherwise, will likely need code that assigns a group identifier for each set of 20 records within each grouping of TEAM_ID and TEAM_CATEGORY.
Provide sample data and desired result. If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.