[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/>