K
Ken Cobler
"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.
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.