Discussion Locked

Access Labels

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.