create records in a new table based on a report once a button is clicked

I have a report in table "A" with a date filter. Upon clicking a button, I want to create in table "B" as many records as the report has. Any suggestions?