Making labels with report - repeating label (1 Viewer)

bigalpha · Jul 18, 2013

I am making labels to stick on containers that we're shipping out. Some shipments will have only 1 container and some will have more than 1.

Can I have it repeat a label if there are more than 1 container for an order?

For example:
Shipment 1 has 3 containers. The label says "3 x DM" and it will make one label.

Can I set it somehow to print that label three times?
What about adding incremental text, e.g. 1 of 3, 2 of 3, 3 of 3?

JHB · Jul 19, 2013

Can't you print out in a loop, then you can add the incremental text.

bigalpha · Jul 19, 2013

JHB said:
Can't you print out in a loop, then you can add the incremental text.

I'm not sure I understand you.

David R · Jul 19, 2013

At a guess, your report query could probably include a DCount function to generate the 3, but not set it as Totals so that each one prints separately?

bigalpha · Jul 19, 2013

David R said:
At a guess, your report query could probably include a DCount function to generate the 3, but not set it as Totals so that each one prints separately?

Can this be done even if there are other labels involved?

Label 1:
Used Oil
1 x 55 gallon DM
(Print 1 label)

Label 2:
Batteries
2 x Pallet
(Print 2 labels)

Label 3:
Mercury
2 x 5 Gallon DF
(print 2 label)

David R · Jul 19, 2013

I don't see any reason why not. I assumed you were using a Totals Query right now to get the '3'?

bigalpha · Jul 19, 2013

Each type of material is listed as one line item in my database with a field for quantity. When we ship, we may ship out a bunch of things but they may only register as a couple of lines in the database.

David R · Jul 19, 2013

Ah, I see. I was thinking you had [Order]->[Item],[Item],[Item]. Your way makes sense though.

However, it's a very interesting problem, because essentially you're reversing the usual Totals Query process. I've never done that, but you could use a temp table and a looped Append Query to make something with just the Order and Item in each record, then join that back to your other tables to print labels from. There is probably a simpler way...

bigalpha · Jul 19, 2013

Yeah, people turn this stuff in to us, then we ship it out for disposal. I haven't found anything that really addresses what I'm trying to do, unfortunately.

David R · Jul 22, 2013

AccessBlaster said:
See if this helps. Print a Quantity of a Label Also if you go to Allen's tip page you can lean how to print what's in the form, which also can be handy.

Richard

Abusing the Cartesian Join for fun and profit...I love it!

bigalpha · Jul 31, 2013

Thanks. Some reason, I didn't get notified that you had posted. I'll take a look and see if I can figure it out. If no, I'll be back.

bigalpha · Aug 1, 2013

Thanks. I'll see what I can patch together with these resources.

bigalpha · Aug 1, 2013

Okay, I got the cartesian result mostly working, along with the "1 of 2" text.

I'm having a problem with the query not showing all the results as soon as I introduce an inner or outer join. The query previously was working correctly and broke as soon as I introduced the cartesian-effect. Is there a way around this?

Making labels with report - repeating label (1 Viewer)

bigalpha

Registered User.

JHB

Have been here a while

bigalpha

Registered User.

David R

I know a few things...

bigalpha

Registered User.

David R

I know a few things...

bigalpha

Registered User.

David R

I know a few things...

bigalpha

Registered User.

David R

I know a few things...

bigalpha

Registered User.

bigalpha

Registered User.

bigalpha

Registered User.

Similar threads

Users who are viewing this thread