add/copy a record multiple times

  • Thread starter Thread starter hansorian
  • Start date Start date
H

hansorian

hi
I have a table with part number and quantity. I want to apply a unique
number to each of the quantity and have a table with multiple lines the same
except for the unique number. Eg Part is 1234 qty 3 so i want 3 rows creating
with a unique number. I need to do this as a query or macro/query etc.... any
ideas?


Regards

IAn
 
You can use a Cartesian effect append query.
Creacte a table named CountNumber with number field name CountNUM containing
0 (zero) through your maximum.
Use a form to enter the number of records and the Part number.
Create your append query, add the CountNumber table, drag the CountNUM field
to the FIELD row, add criteria --
Between 1 AND [Forms]![YourFormName]![NumRecordsTextBox]
 
hi
i dont quite understand what you are saying..... however i shall try to
digest it and see if it answers my problem... thanks in advance.

i need the table to create itself from just a part number and qty then to
create the rows with perhaps other info from another table aswell... with
what you suggest will that happen?

thanks

Ian

KARL DEWEY said:
You can use a Cartesian effect append query.
Creacte a table named CountNumber with number field name CountNUM containing
0 (zero) through your maximum.
Use a form to enter the number of records and the Part number.
Create your append query, add the CountNumber table, drag the CountNUM field
to the FIELD row, add criteria --
Between 1 AND [Forms]![YourFormName]![NumRecordsTextBox]

--
Build a little, test a little.


hansorian said:
hi
I have a table with part number and quantity. I want to apply a unique
number to each of the quantity and have a table with multiple lines the same
except for the unique number. Eg Part is 1234 qty 3 so i want 3 rows creating
with a unique number. I need to do this as a query or macro/query etc.... any
ideas?


Regards

IAn
Click to expand...
Click to expand...
 
Yes, but make sure you use criteria to append the correct part number and qty.

If using a record from within the table then along with the criteria stated
above use this --
Between 1 AND [QTY]

--
Build a little, test a little.


hansorian said:
hi
i dont quite understand what you are saying..... however i shall try to
digest it and see if it answers my problem... thanks in advance.

i need the table to create itself from just a part number and qty then to
create the rows with perhaps other info from another table aswell... with
what you suggest will that happen?

thanks

Ian

KARL DEWEY said:
You can use a Cartesian effect append query.
Creacte a table named CountNumber with number field name CountNUM containing
0 (zero) through your maximum.
Use a form to enter the number of records and the Part number.
Create your append query, add the CountNumber table, drag the CountNUM field
to the FIELD row, add criteria --
Between 1 AND [Forms]![YourFormName]![NumRecordsTextBox]

--
Build a little, test a little.


hansorian said:
hi
I have a table with part number and quantity. I want to apply a unique
number to each of the quantity and have a table with multiple lines the same
except for the unique number. Eg Part is 1234 qty 3 so i want 3 rows creating
with a unique number. I need to do this as a query or macro/query etc.... any
ideas?


Regards

IAn
Click to expand...
Click to expand...
Click to expand...
 
Back
Top