G
Guest
I need to divide a table of approximately 1200 records into three fairly even
groups. So far, I have created an autonum field and get the total and on a
calculator divide by 3 and then create 3 identical queries. In one I put
'<400' in another 'Between 400 And 800' and in the last one '>800'.
However, each day this table's total changes and thus these subsequent
totals change.
Is there a way to automate this.
Thank you.
groups. So far, I have created an autonum field and get the total and on a
calculator divide by 3 and then create 3 identical queries. In one I put
'<400' in another 'Between 400 And 800' and in the last one '>800'.
However, each day this table's total changes and thus these subsequent
totals change.
Is there a way to automate this.
Thank you.