Creating an address book

[faythe1215]

I have a list of people with phone numbers, addresses, and email addresses. I would like to generate a report that lists every phone number, address, and email address associated with the person (like a contact sheet) or have each person listed one after the other with all the information displayed (like an address book).

[ranman256]

Use the report wizard to do it. Pick your table, fields, and then arrange them how you like.

[faythe1215]

I think I may have needed to be more elaborate with my information.

I have tblPerson and tblAddresses. There may be multiple instances of Address that related to an individual Person (office and home) or there may be only one. The same is true of tblEmailAddress and tblPhoneNumber. How can I get all of the information to display in a report such that it would appear as below - ignoring areas that are not filled in and having multiple addresses displayed if appropriate:

John Smith
Office Address
123 Main Street
New York, NY 12345
(123) 456-7890
Home Address
1245 Second Street
Somewhere, NY 12345
(234) 567-8901

Jane Doe
(425) 124-7474

[NoellaG]

Hi,

you could try to build a report based on tblPerson with subreports for the adresses, the tel. numbers and the e-mails.