Distribute Acccess Records Evenly
Posted on 2013-10-21
I have 2 holding tables BEQH & TSOH (access 2010 windows 7).
they will contain any variable number of recs each day - 20 to 6051 plus etc etc.
I have 8 work tables to put them in distributed evenly depending on how many people we have for the days work, (Beq1-thru8 & Tso1thr8) they have a unique identifier in both tables of a text field called "Dtlseq" this allows me to match recs. (Beq1 rec 0000001 = tso1 rec 0000001.
I want to develope a process that will ask the processor how many tables to break out
so it will prompt him with an input box and he will input 2 thru 8
this will allow the process to somehow divide the records evenly across the number of work tables to include an odd record count here and there.
I am not bad at coding so I am assuming this can't be done by queries and will require a function. Anyone with experience that can give me a start in how to accomplish this?