B
Baxter101
I am trying to create queries to sort church membership data according to any
number of ministry groups (out of a possible 56) they volunteer for. My goal
is to create a report for each of the Ministry's with name and contact
information. I have some questions with corresponding database description
information that will hopefully enable an expert to point me in the right
direction...
Questions:
(1) I am at the query step and am looking for a way to link up the ministry
with the corresponding FName. I have entered a ministry name in the criteria
cells (e.g., "Choir") for all 28 cells in the design grid and this works in
that it only brings up those records that have "Choir: in any of the Ministry
fields, but does not really link up the FName with the ministry. For example,
FName1 could be in Choir and Fname3 could be in Sunday School. So I need
directions to get to a point with FNames and associated Ministries.
Background:
Each record contains first and last name fields for up to 7 family members (e.
g., FName1...FName7). Also, each record contains fields for up to 4
ministries for each of the 7 family members (e.g., Ministry1A...Ministry7D).
Thanks in advance for your time and assistance!
Brandye
number of ministry groups (out of a possible 56) they volunteer for. My goal
is to create a report for each of the Ministry's with name and contact
information. I have some questions with corresponding database description
information that will hopefully enable an expert to point me in the right
direction...
Questions:
(1) I am at the query step and am looking for a way to link up the ministry
with the corresponding FName. I have entered a ministry name in the criteria
cells (e.g., "Choir") for all 28 cells in the design grid and this works in
that it only brings up those records that have "Choir: in any of the Ministry
fields, but does not really link up the FName with the ministry. For example,
FName1 could be in Choir and Fname3 could be in Sunday School. So I need
directions to get to a point with FNames and associated Ministries.
Background:
Each record contains first and last name fields for up to 7 family members (e.
g., FName1...FName7). Also, each record contains fields for up to 4
ministries for each of the 7 family members (e.g., Ministry1A...Ministry7D).
Thanks in advance for your time and assistance!
Brandye