Query for each record

[tkoh78]

I have a form that is set as "continuous forms" view.
I would like to run a single query or macro which will run for each record.

For example,

I Have 5 records.
I have an append query.
I would like to run a query once to append all five records.
Here is a problem. I want to append first record 7 times, second record 5 times, third record 2 times... you get the idea.

I know that people would say "why create duplicates?" However, this is something that I need to do. Let's say I am experimenting.

Thanks for your help in advance.