Looping Append or import Spec

[ATHConsulting]

I need to write either an append query or an import Spec where the user can put in a number that represents how many times a row of data gets imported or appended to a table. I think it's a loop, but I don't know how to do it.

Thanks a million!!!!!!!!!!

 

[Golom]

Few questions ...

Are you saying that you want duplicate records APPENDED to an existing table?

If so, do you want EVERY appended record duplicated that number of times?

... and what's the point of having duplicate records anyway?

 

[ATHConsulting]

Thanks for responding. What we want to do is create a record in a table and then use a form to append this record to a production table a determined amount of times with an autonumber distinguishing the new records. Each new append could have a different amount of duplicates created Does this make sense?

It's for a production database where they want to keep track of sets of vials. All the sets would share the same information but would need different record # so that they can be stored in different areas.