duplicate records for labels

[Guest]

"Duplicate" is not perhaps the best word to use..

I have a movie database for my DVD collection. Some DVDs are contained on 2
disks when they come with special features. Each record includes a single
movie title, plus other info, plus a number field for the "total" number of
disks upon which the film is contained. (e.g. "MovieTitle, YearMade, 2").

I would like to make envelope lables where they specify "Movie Title" and
"Disk 1 of 2" and "Disk 2 of 2". (I don't need "Disk 1 of 1").

Besides entering two db records for each multi-disk film, what is the best
way to make a query that would give me double labels and the correct logic to
have the labels be "x of y" and "y of y"?

Thanks for your help. Please let me know if you need more background.

 

[Allen Browne]

See:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[Guest]

Thank you. That was the clear and simple solution I was looking for. It
works perfectly.