Multiple Labels from one record

  • Thread starter Thread starter DubboPete
  • Start date Start date
D

DubboPete

Hi all,

I have a report for labels, which is currently printing one label per
record. What I would like to do is print multiple labels from the
same record.

Presently a label is printed if the record is marked for printing
[check-box], but I want to expand this to print a label for every
instance that other checkboxes are checked [seven boxes, days of the
week].

For instance, if one record has a tick in [mon], [tue] and [sat], and
ticked [marked for printing], then three labels should appear on the
print run.

Any suggestions out there?

tia

DubboPete
 
The easiest way to do this would be to modify the data source for the report
(presumably a query) to have the record repeat itself as often as necessary
to fulfill your requirements.

Ron W
 
Add a text box to your report, and give it thest properties:
Control Source: =Abs([sun]+[mon]+[tue]+[wed]+[thu]+[fri]=[sat])
Name: Quantity
Format: General Number
Visible: No

This text box gives you the number of labels you need. Then you can use this
article to print the number of labels you need:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html
 
Hi Ron and Allen,

Sorry but I didn't elaborate enough in the first place. What you have
explained works great.

But, I didn't elaborate that each label must contain that specific day's
"date", which is in the future from the processing date...
so labels for sun, mon and wed [prepared on the previous Wednesday 7th July
04] must each bear an individual date, ie 11-7-04, 12-7-04 and 14-7-04...

I think the easiest way is to create a temporary labels table in the
processing stage, and append a new record for each label with future dates
automatically calculated.

Thanks for your help anyway! much appreciated

DubboPete

Ron Weiner said:
The easiest way to do this would be to modify the data source for the report
(presumably a query) to have the record repeat itself as often as necessary
to fulfill your requirements.

Ron W
DubboPete said:
Hi all,

I have a report for labels, which is currently printing one label per
record. What I would like to do is print multiple labels from the
same record.

Presently a label is printed if the record is marked for printing
[check-box], but I want to expand this to print a label for every
instance that other checkboxes are checked [seven boxes, days of the
week].

For instance, if one record has a tick in [mon], [tue] and [sat], and
ticked [marked for printing], then three labels should appear on the
print run.

Any suggestions out there?

tia

DubboPete
Click to expand...
Click to expand...
 
OK a temp table if you want, but you can likely do the same thing with a
query. You do not give us any inkling of your data structure so it is VERY
difficult for us to give you an example. It sounds like you may have a
table of things that have a column [PrintLabels] and another table with the
dates that the labels are required for. This would a pretty easy query that
might look like:

SELECT TableOfThings.SomeColumn, TableOfDates.LabelDate,
Format([TableOfDates].[LabelDate],'ddd') AS Weekday
FROM TableOfThings INNER JOIN TableOfDates ON TableOfThings.PKey =
TableOfDates.FKey
WHERE TableOfDates.LabelDate Between #[Start Date]# And #[End Date}# AND
TableOfThings.PrintLabels = True
ORDER BY TableOfThings.SomeColumn, TableOfDates.LabelDate

The above will return all of the data to be put on labels between the dates
and where the PrintLabels column is true.

If your data doesn't look like this, let us know what it does look like and
I am sure that someone will be able to help you.

Ron W
DubboPete said:
Hi Ron and Allen,

Sorry but I didn't elaborate enough in the first place. What you have
explained works great.

But, I didn't elaborate that each label must contain that specific day's
"date", which is in the future from the processing date...
so labels for sun, mon and wed [prepared on the previous Wednesday 7th July
04] must each bear an individual date, ie 11-7-04, 12-7-04 and 14-7-04...

I think the easiest way is to create a temporary labels table in the
processing stage, and append a new record for each label with future dates
automatically calculated.

Thanks for your help anyway! much appreciated

DubboPete

Ron Weiner said:
The easiest way to do this would be to modify the data source for the report
(presumably a query) to have the record repeat itself as often as necessary
to fulfill your requirements.

Ron W
DubboPete said:
Hi all,

I have a report for labels, which is currently printing one label per
record. What I would like to do is print multiple labels from the
same record.

Presently a label is printed if the record is marked for printing
[check-box], but I want to expand this to print a label for every
instance that other checkboxes are checked [seven boxes, days of the
week].

For instance, if one record has a tick in [mon], [tue] and [sat], and
ticked [marked for printing], then three labels should appear on the
print run.

Any suggestions out there?

tia

DubboPete
Click to expand...
Click to expand...
Click to expand...
 
Back
Top