Most of our customers require a shipping label for each item in a shipment.  It must include Customer Name (or Ship To name for a drop shipment), their PO number, the item number, part number, description and quantity. Unfortunately DBA does not offer all of this info on one RTM report.  We can get header info or detail info but not both.  
 
Does anyone else have customers that require this info?  If so how do you do it?  Lynn, would it be possible to get this information on one RTM.  We are currently doing this by hand and it takes quite some time.

Does Access allow the option of adding Bar Codes to the label as well?  We are needing to implement bar coded labels for our customers and I'm trying to figure out the best way to implement without re-keying anything.
 
Thanks,
Shannon

This label has to conform to a John Deere World Wide standard - which dictates everthing from what needs to be on the label to which symbol code and what pitch to use.  
 
They are asking for Part Number, Qty, Description, Trigger# (comes off EDI), Serial Number (Use Pack List#), Location (comes off EDI), Supplier, Dept, PO#, Ship Codes and Ship Address.
 
We use a seperate program for EDI, so I was hoping to use Access to pull information from there and then also have the capability for labels out of DBA for other customers down the road.
 
Think we can make it work with an RTM?

Next question.  Access 2000 is Win 2000/XP compatible.  The workstation that handles all the shipping paperwork is a Win98 machine.  Is it possible to compile a label program/report to be used on that workstation?
 
Thanks for your help,
Shannon