Creating a new table to combine records ie. Mr and Mrs.

[Guest]

Hello I would appreciate any advice you may offer.
I am working with a database with approx 300 individual records on members
of a church. I need to be able to do mailing labels to both husband and wife
on one label. I also need to track contributions made by them together. My
thought is that I need to create a new table which would list both his and
her name. Is there a sample query that would do this?
Thank you so much.

 

[John Vinson]

Hello I would appreciate any advice you may offer.
I am working with a database with approx 300 individual records on members
of a church. I need to be able to do mailing labels to both husband and wife
on one label. I also need to track contributions made by them together. My
thought is that I need to create a new table which would list both his and
her name. Is there a sample query that would do this?
Thank you so much.

I'd approach this with caution. My name's John Vinson; I've been
happily married since August 1972 to Karen Strickler. She'll answer to
Mrs. Vinson but it's only after a doubletake. This is pretty common
these days!

I have a church membership database that I've written (in use at
several churches, and available if you want it); what I decided to do
was to have a Families table with the address, and a text field for
the family joint name ("John Vinson & Karen Strickler" for my family,
"Jim and Helen Sparks" for another, "Mr. & Mrs. J. C. Riley" for a
third, depending on how they prefer to be addressed). It's related
one-to-many to a People table with the individual names.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Allen Browne]

Hi Lynn

This question has been asked several times, so I've created a *very* basic
example of how to approach this. You can download the 20kb zip file for
Access 2000 and later from:
http://allenbrowne.com/household.zip

Sounds like John may have a more comprehensive example. My minimal example
sounds similar to his, in that you can specify the "addressee" separately
from the names of the individuals.