possible to repeat report three times?

[Ohmes, Matt]

Hi Stephen and Guy,

(Second try, first message was too big because I included all the
earlier replies.)

 

I don't think the Set Page Images will work. That will still only print
all records one time each.  It sounds like you want 3 copies of each
record, right?

 

There is an old technique for doing this using what I call a 'copies'
file. It is a simple file (usually indexed) that contains only 2 fields.
The first field is called Kount and contains sequential numbers (i.e. 1
for the first record, 2 for the second, etc.).  The second field I
usually call X and contains a constant value (say "X"). Make this field
a repeating index.

 

The file, for your purposes, must contain at least 3 records (you could
make it more general purpose by putting 10 or 20 records but that is not
required in your case). Name the file Kopies.

 

You now add this file to your Access statement something like this:

Access Your_Existing_File Link ('X') to X of Kopies

 

Then, in your Select statement you add the extra constraint:  "And Kount
of Kopies < 4".

 

To understand how this works, think of  "Access Order_Header Link to
Order_Details" .  There is only one Order_Header record, but you get as
many record complexes as you have Order_Detail records.  And all the
Order_Header information duplicated in each of those record complexes.

 

We are simply using the Kopies file to make 3 record complexes, each
containing a copy, of the original record. So you have 3 copies of
record 1, 3 copies of record 2, and so forth.  You don't actually use
any information from the Kopies file; you just use it to make extra
copies of the main record.

 

Hope that makes sense. Good luck! :-)

Matt
 
     This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080214/8aff8a5b/attachment.htm