Insert set number of rows into table based on value in field

[Rob]

I'm working with an Access 2002 adp and i'm looking to insert records into a
table based on a number entered into another table. The senario is tableA
has a field "Employees" which is used to record the number of employees for
a company. I would like to insert the same number of rows into tableB as
number entered in tableA.employees but not sure how to approach this??
any suggestions would be great.

thanks
rob

 

[Rod Gill]

Hi,

This is a Microsoft Project group, so try posting to an Access VBA group.
You should also state whether you use ADO, DAO and whether the data is in a
..mdb file or SQL Server or...

You should also list all key fields in the table because if you have a key
field or no duplicates index you will need to pre-fill with unique values
for the record add to work.

 

[Rob]

Yeah realized i hit wrong group too late... sorry about that...
thanks for advice
rob