Discussion Locked

Access report repeating a label

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by john_wills

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.

by timfox

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

This discussion is closed to new replies.