To display duplicate data on label report

[Pozko]

In a DB of Student data I need to print 4 identical labels for each Student. My label report is query-based and uses the following criteria in the Student ID field:
"[Enter 1st ID] Or [Enter 2nd ID] Or [Enter 3rd ID] Or..." etc. If I enter the same Student ID several times the report still only displays the data on one label! "Hide Duplicates" is set to "No" in all fields on the Report. Help!

Also, is there a 'cleaner' method of entering the Student IDs for those requiring labels? Since the maximum number of Students wanting labels at one time is 20, the Query Criteria ends as such: "...Or [Enter 20th ID]". What if I only want labels for 2 Students? Do I really have to go through all 20 parameter values before the report is displayed?

Thanks in advance

 

[shay]

Suggest you create a table containing the IDs of students for whom you want labels and include this table in your query, joined to your current table by Student ID.

You could create a form with a combo/list box (bound to the Student ID field in the new table) from which you select the students you want to print labels for.

As for printing 4 labels per student, the only way I can think of is to have a dummy table which contains 4 records. Include this dummy table in your query but don't join it to any of the other tables. This will give you your results 4 times.

hth

shay

 

[Oldsoftboss]

Try downloading the DB from http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=39516
I adapted it to my label thingy.
Dave

 

[shay]

I'd nothing much to do today so I've knocked up a demo file (A97) for you. Can't take credit for the code for moving things between list boxes - pinched it from a db I downloaded from some web site!

hth

shay

 

[Pozko]

Almost solved!

Well, I've kinda sorted it. Firstly, I modified the Label Report by grouping the displayed fields and then duplicating them 3 times down the left side of the report. This solved the printing of 4 duplicate labels. Unfortunately, as I'm using a 3 by 6 label sheet, it leaves 2 rows of 3 labels at the bottom of each page. Not very elegant.
So then, at Oldsoftboss suggestion I downloaded Label Saver at http://www.peterssoftware.com/ls.htm. This is almost perfect. Thanks!
I just gotta figure out why it also leaves a couple of rows at the bottom of each sheet and Voila!

Thanks folks