I have a membership database. The names and addresses are in the Members table, and I have three other tables (linked by a membership number) for email addresses, phone numbers, and notes. These are set up in the Members table as subdatasheets. I have these additional tables so that I can store multiple phone numbers, email addresses, and notes for each member.
I want to print a report containing all the information for each member, something along the lines of:
Name
Address
phone number 1
phone number 2
phone number x
email address 1
email address 2
email address x
note 1
note 2
note x
(multiple members per page, separated by a line).
I couldn't successfully set up a single query with all the data from each table, so I set up four separate queries, one for each table. How do I pull those four queries together into a single report? Is there a better way to do it (maybe I'm not setting up the single query correctly)?
I want to print a report containing all the information for each member, something along the lines of:
Name
Address
phone number 1
phone number 2
phone number x
email address 1
email address 2
email address x
note 1
note 2
note x
(multiple members per page, separated by a line).
I couldn't successfully set up a single query with all the data from each table, so I set up four separate queries, one for each table. How do I pull those four queries together into a single report? Is there a better way to do it (maybe I'm not setting up the single query correctly)?
