Elam, Debbie
DElam at jenkens.com
Wed Jun 21 10:03:41 CDT 2006
That makes it tougher. Can you be sure that all of addresses are identical, or is the first row some sort of ID field? If it is, then I would probably try to build the string of names in a function and call it to put that data in the label. If you do not have a certain way to group the addresses, then someone is going to need to go through the addresses manually, though some auto processing can be done ahead of time. Either and extra field in the table, or an extra table to group them is needed. Debbie -----Original Message----- From: Martin Reid [mailto:mwp.reid at qub.ac.uk] Sent: Wednesday, June 21, 2006 9:50 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Mailing Labels Debbie its all in one table and has to stay like that. Its the way they get the data and unable to change it. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of Elam, Debbie Sent: Wed 21/06/2006 15:39 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Mailing Labels Do you have the design already in place or do you already have this all on one table? Debbie -----Original Message----- From: Martin Reid [mailto:mwp.reid at qub.ac.uk] Sent: Wednesday, June 21, 2006 9:11 AM To: Access Developers discussion and problem solving Subject: [AccessD] Mailing Labels Given the following data 1234,Name,Address 1234,Name,Address 1234,Name,Address 1234,Name,Address 2345, Name Address 2345,Name Address I need to get one mailing label produced 1234, Name1, Name2,Name3,Name4 Address 2345,Name1,Name2 Address Etc So I can have multiple people at the same address. I need the name line to include all the names but only produce 1 label per address. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions.