How to Insert a Variable Number of Records into an Access Table Based on a Fields Value

I have an Access Table with the following columns: WeeklyID(PrimaryKey), CampaignID(Foreignkey), WeekEnded(Date Field), Duration(Number Field).

I want to automatically add X number of records to the table, where X is the number stored in the Duration field. I want the added records to have the same CampaignID as the original record. So the automated process would be satisfied when the count of the records with one specific CampaignID was equal to the Duration number.

If anyone could provide assistance on how to accomplish this, it would be much appreciated. If you need any further info, please ask!