thanks for your input!!
Access can link to Excel data (no need to export). Then a query can return records 1-500, 501-1000, etc. I can provide the query if you're not too fluent in SQL
-PPLandry
likewise Excel can access and control access (no need to export)
and I can break the data into 500 row blocks without using anything else, but this isn't what I'm hoping to do
an example -
source data is 2000 records
of this there are 750 tagged ABC001, 100 tagged as ABC002, 1100 as ABC003, 50 as ABC004, etc
the idea is to subtotal the groups
ABC001 - 750
ABC002 - 100
ABC003 - 1100
ABC004 - 50
then sort them so they fit into the 500 record limit
group 1 - 500 X ABC003
group 2 - 500 X ABC003
Group 3 - 500 X ABC001
Group 4 - 100 X ABC003 & 250 ABC001 & 50 ABC004
the result would be either to tag each record with a group ID, or output as distinct blocks of data (i haven't really thought this far yet...)
Target