General discussion

Locked

Access report repeating a label

By john_wills ·
I want several identical copies of a label in Access. The data for the label is in a one-record table. I can do this by repeating the record n times through a new table, or via a Word document, but I would prefer to do it within Access, presumably using the Report facility. Any ideas?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Access report repeating a ...

yep. easy. Reports/New/Label Wizard...

Collapse -

by john_wills In reply to

This will give me one label for each row in the table or query, as I have so far understood things. If you know how to repeat the one row's infomration many times, do tell. But don't expect a quick response because I'm going on vacation this afternoon.

Collapse -

by timfox In reply to Access report repeating a ...

The only way that I can think of is to assign values yourself, via a function that returns the same values each (and every) time.
The limitation to this technique is repeating the label values for as many labels as you want. I have done this by linking the report's datasource to a table that has as many rows as I want labels, but I would cahnge this to creating a dummy table with as many rows as labels, then delete the dummy table after each time I create my label report.
(I can email an example, if required.)

...but you might be better off just creating a "label table" instead, repeating row values as many times as you require.
Cheers
TimFox

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums