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" wrote:
> 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" wrote:
>
> > 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" wrote:
> >
> > > 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
|
Similar Threads
