mailing labels - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

mailing labels

William DeGrandis

3 years ago

I have a database of Addresses. I setup a different table for names than a table for prefix like Mr. and Mrs. My question Is can I combine two records Into one field? I give you a example I have a table with Joe as one record and Mary as another record. Can I put Joe and Mary togeher so I can use It to print a lable?

	Alex Hedley @Reply 3 years ago
Access Mailing Label Seminar Access Mailing Label Template

	Sami Shamma @Reply 3 years ago
see also the Tech Help on "concatenation".

	William DeGrandis OP @Reply 3 years ago
Yes I know how to concatenation but that has to be in the same record. I have a database with all names so the field Name Is first name. So I would like to combine two records?

	William DeGrandis OP @Reply 3 years ago

	Scott Axton @Reply 3 years ago
William are the records related in any way? Do you have a linking ID for say a husband and wife? In other words how do you know the people are in the same household? You are probably going to need a Self-Join Query to determine that. Take a look at the Self Join Relationships. I know it was covered in the Access Relationship Seminar

	Sami Shamma @Reply 3 years ago
Show sample of your data. in the example you gave how would you know that Joe & Mary belong together? what is the link?

	Scott Axton @Reply 3 years ago
Also, go watch the Holiday Cards. Specifically the extended cut where Richard show how to combine names for the Greeting line.

	William DeGrandis OP @Reply 3 years ago
So If you look at the sample, I want to take Alexis "UniqueFirstNameID 1" and Bill "UniqueFirstNameID 2" together. I don't think I can use concatation.

	William DeGrandis OP @Reply 3 years ago
yes I have them link by ID's.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View