P
Pastor John
I am a pastor who is using Access to maintain church records. I want to
create a report either in Access or in Word through merge that would be
a directory. Each family record would look as follows:
Head of House Phone #
Spouse
Children
Address
While this seems straight forward my problem lies within my tables.
I have one table for families which store the family address, etc
I have a second relevant table for individuals which stores birthdays,
membership, attendance, etc.
For purposes of the directory I have created a field in individuals that
takes a 1 for Head of House, 2 for Spouse and 3 for children and other
I created three queries to search for one, two and three - though there
must be an easier way. This works except where multiple children are
involved - then the form shows record 1 with child 1; record 2
duplicates except for child 2, etc.
I tried a subform - but Access doesn't like using subforms with three
queries and refuses to allow me to bind the subform which makes it
useless.
Any help or ideas would be appreciated.
Pastor John
create a report either in Access or in Word through merge that would be
a directory. Each family record would look as follows:
Head of House Phone #
Spouse
Children
Address
While this seems straight forward my problem lies within my tables.
I have one table for families which store the family address, etc
I have a second relevant table for individuals which stores birthdays,
membership, attendance, etc.
For purposes of the directory I have created a field in individuals that
takes a 1 for Head of House, 2 for Spouse and 3 for children and other
I created three queries to search for one, two and three - though there
must be an easier way. This works except where multiple children are
involved - then the form shows record 1 with child 1; record 2
duplicates except for child 2, etc.
I tried a subform - but Access doesn't like using subforms with three
queries and refuses to allow me to bind the subform which makes it
useless.
Any help or ideas would be appreciated.
Pastor John