Discussion Locked
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I create labels in Access that repeat 1 record on all labels on the page, and then the next page has the next record, etc.?
1 reply
by it_cowboy
first determine how many labels fit on one page (value = X).
then create a table and create 'X' number of records (doesnt matter whats in the records, as long as there is X number of records).
create a query with the table containing your labels and the newly created table, do not join the tables.
the resulting query will repeat each record in the labels table for the number of records that exist in the new table (this is called a cartesian join)
i know, i know. its a little dodgy, but hey, it gets results.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
Question Unanswered
Best Low-Latency VPN Protocols for Competitive Mobile and Online Gaming
0 helpful
0 replies
0 helpful
5 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies