ACCESS FEED: RE: [MS_AccessPros] Makeing multiple copies of a record to a temp table

Rabu, 12 Oktober 2011

RE: [MS_AccessPros] Makeing multiple copies of a record to a temp table

I don't recall seeing an answer to this question.

I typically have a table of numbers [tblNums] with a single numeric field [Num] with values from 1 to some big number. You can add this table to a query without joining it to any other table. Add the Num field to the query grid and set the criteria to:

<=[NumberToPrint]

This should create NumberToPrint copies of each record.

Duane Hookom
MS Access MVP

________________________________
> From: wgriffin48@mchsi.com
>
> Hi Group;
> I think this has to be a lot simpler than my last question.
> I have a table with a field "NumberToPrint" for each record, how do I
> cause the record to replicate itself x number of times to the temp
> table?
> Walter Griffin