Report Duplication based on Field Entry

[AFuturePrez]

I am working on a database that will print placards for use in a
warehouse. The placards contain product specific information and must
be reconciled meaning that if 12 placards are placed on the product 12
must come off of the product. I have the number of placards needed
stored in a field. However, I need the report (placard) to generate
itself the number of times in the field. On top of that I need to
have the placard print # of ## placards on it.

Essentially, I am looking for the report page (placard) to duplicate
itself on subsequent pages the number of times listed in the specific
field.

Any help would be greatly appreciated!

Thanks,

JMT

 

[John W. Vinson]

I am working on a database that will print placards for use in a
warehouse. The placards contain product specific information and must
be reconciled meaning that if 12 placards are placed on the product 12
must come off of the product. I have the number of placards needed
stored in a field. However, I need the report (placard) to generate
itself the number of times in the field. On top of that I need to
have the placard print # of ## placards on it.

Essentially, I am looking for the report page (placard) to duplicate
itself on subsequent pages the number of times listed in the specific
field.

Any help would be greatly appreciated!

Thanks,

JMT

One handy way to do this is to create a little table Num with one Long Integer
field N. Fill it with values from 1 to more than the most placards you'll ever
need - be generous, a 10,000 row table is still tiny.

Open the Query upon which your report is based, and add Num to it, with no
join lines at all.

Put a criterion on N of

<= [NumberNeeded]

This "cartesian join" query will contain that many repeats, and the N field
will have values from 1 through the number needed, and can be displayed on the
report.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[AFuturePrez]

I am working on a database that will print placards for use in a
warehouse.  The placards contain product specific information and must
be reconciled meaning that if 12 placards are placed on the product 12
must come off of the product.  I have the number of placards needed
stored in a field.  However, I need the report (placard) to generate
itself the number of times in the field.  On top of that I need to
have the placard print # of ## placards on it.

Essentially, I am looking for the report page (placard) to duplicate
itself on subsequent pages the number of times listed in the specific
field.

Any help would be greatly appreciated!

JMT

One handy way to do this is to create a little table Num with one Long Integer
field N. Fill it with values from 1 to more than the most placards you'llever
need - be generous, a 10,000 row table is still tiny.

Open the Query upon which your report is based, and add Num to it, with no
join lines at all.

Put a criterion on N of

<= [NumberNeeded]

This "cartesian join" query will contain that many repeats, and the N field
will have values from 1 through the number needed, and can be displayed on the
report.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com- Hide quoted text -

- Show quoted text -

Worked like a charm!!! Thanks!