Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

printing records more than once

Status
Not open for further replies.

JeroenBoon

Technical User
Aug 15, 2002
106
NL
Hello,

I have the following question: is it possible to print detail records more than once?
For example: based upon the table Article I print some information of the article on a piece of paper to stick on the box the article is in. But I want to stick the same info on two sides of the box: so in this case I need the info two times, while CR retrieves the info once. Is there a way to do this?

Greetings, JeBe.
 
Hi,

You can simply do it by creating an additional table with only 2 records inside, then add the table to database expert without joinnnig it with the logic tables, however, you will get warning for that which you can just ignore it, after that, you will get your records twice in preview.

it may not be the best solution, but it works fine for me.

Ted
 
On any section, you can right-click and choose [Insert Section Below]. You can then print the details twice. You can even print them on different pages, if you wish, uisng right-click, Section Expert, New Page After.

The options can also be made conditional, using the formula icon (x+2 and a pencil). You;ll probably find that useful for other reports, even if you don't need it for this one.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top