Adding multiple new records in Access

[dkuzminski]

I wish to create multiple records in an Access table based upon a single record from another Access table. Yes, the records will be identical. Also, the number of records will vary based on user input. These records will be exported to another custom-written database where more data will be added.

Basically, the user will enter the record number he wants replicated and how many to make. It's essentially a way for us to replicate common data and cut down on data entry time.

 

[PWise]

Create a digits table

digitid
1
2
3
4
.....
10000

run this qurery
insert into(table2)(field1,field2,field3)
Select feildA,fieldB,fieldC
from table,digits
where fielda=xxxxx and digitid<=3

change tablenames and filedname

 

[dkuzminski]

Thank you. A variation of that worked.

 

[SkipVought]

I wish to create multiple records in an Access table based upon a single record from another Access table.

Hmmmmmm?

Seems as if your 'single record from another Access table' ought to be linked to 'another custom-written database where more data will be added,' and your 'multiple identical records' ought to be scrapped. It is not a good or best and accepted practice.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dkuzminski]

The other database is a cancer database with close to a million records in it and each is over 20,000 bytes in length. We add on average about 28,000 cases each year for just our state. This function was needed because the other program is unable at present to create a batch of similar files for records coming from multiple sources which are then segregated by type of cancer before entry. Having the ability to create the defaults on a file before it's imported is very useful to us especially since we're dealing with individual records that have unique defaults for 94 of the cancer types we input into the system.By creating these records, we save the cancer specialists a great amount of time from looking up each of the different defaults and in data entry.

And yes, I finished the new program and it works quite well. I do wish to thank those who helped me with this.