I have a table that I generate for a fax list to an associations customer base. We need to fax quicker so we want to divide the table into 3 separate tables so that we can utilize multiple workstations using the extra tables linked into WinFax. I know exactly how to calculate how many of the records I want to move to the two additional tables. I am thinking we start with the original table and move x records to the two tables leaving the balance (due to rounding) in the original table. Can someone please advise me on the code that I use to move x records to table B and x records to table C. Think of it as cutting and pasting x records from one table to another. Thanks!
Start Free Trial
