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.
--
Sincerely,
Lynn

On Thu, 2 Dec 2004 20:37:02 -0800, Lynn Carlton
<(E-Mail Removed)> wrote:

>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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lynn Carlton" <(E-Mail Removed)> wrote in message
news:BF64594F-C929-4F54-9091-(E-Mail Removed)...
> 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.
> --
> Sincerely,
> Lynn