S
Scott
I have a database of family names and data. I need a summary query or report
that combines the husband and wife names on one line with their phone number.
The fields in the table are PersonID, FirstName, LastName, Phone, Address,
City, Zip, Family ID. Each individual has a separate record. The head of
household has a Family ID of 1, the spouse a Family ID of 2, and the children
a Family ID of 3, 4, 5, etc. In a report or query I need to combine the
record for Head of Household and Spouse for each family by combining the name
with a Family ID of 1 with Family ID 2 (the head of household and spouse)
into one line on a query or report. So the record for John Doe and the
record for Jane Doe would be combined into one record reading John & Jane Doe
with John Doe's Phone number. How can I accomplish this?
that combines the husband and wife names on one line with their phone number.
The fields in the table are PersonID, FirstName, LastName, Phone, Address,
City, Zip, Family ID. Each individual has a separate record. The head of
household has a Family ID of 1, the spouse a Family ID of 2, and the children
a Family ID of 3, 4, 5, etc. In a report or query I need to combine the
record for Head of Household and Spouse for each family by combining the name
with a Family ID of 1 with Family ID 2 (the head of household and spouse)
into one line on a query or report. So the record for John Doe and the
record for Jane Doe would be combined into one record reading John & Jane Doe
with John Doe's Phone number. How can I accomplish this?