Duane;
Thanx that worked but it made a big mess out of the reports, 10 reports on a piece of card (think business cards) print double sided and the ID was used in the formatting calculations for positions on the sheet. been thrashing all day and I have it working
Walter
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> 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@...
> >
> > 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
>
Tidak ada komentar:
Posting Komentar