Print multiple label base on a table field qty (1 Viewer)

m2boost

New member
Local time
Today, 11:01
Joined
Nov 7, 2019
Messages
8
Hi all,

I had never done something like this and looking for some help.

I have a Table ([tlbStickerData]) that contain a field ([Nest Qty]) and I'm looking to print a label report ("LblStickerData") but my output to be base on the [Nest Qty] from my table.

I have all the format on my label done and I can printed but if the [Nest Qty] in my table is 2 I like the output to be 2 labels for that line of data in my table.

Any help will be appreciate! :banghead:

Thanks,

Ernie
 

jdraw

Super Moderator
Staff member
Local time
Today, 11:01
Joined
Jan 23, 2006
Messages
15,364
See if this material helps and/or could be adapted.
You should avoid embedded spaces in field names --they will lead to syntax issues. Use only alpha/numerics (and "_" if needed) for names.
Good luck.
 

m2boost

New member
Local time
Today, 11:01
Joined
Nov 7, 2019
Messages
8
That's perfect and simple! Thanks for the help jdraw!!!!! :D
 

jdraw

Super Moderator
Staff member
Local time
Today, 11:01
Joined
Jan 23, 2006
Messages
15,364
10-4 Good luck with your project.
 

m2boost

New member
Local time
Today, 11:01
Joined
Nov 7, 2019
Messages
8
Thanks again jdraw, it was the last piece to the puzzle that I was missing.

The DB just take a data dump (CSV) files and import them into a table on access then remove the CSV files from my network drive. I using that data to generate labels but as part of the data it tell me how many pieces they are, that's where I was need to print a label for each pieces :)

All working like a charm now... thanks for the info!
 

Users who are viewing this thread

Top Bottom