AnsweredAssumed Answered

Multi-column "address book" report

Question asked by rmittelman on Feb 14, 2014
Latest reply on Feb 20, 2014 by rmittelman

This should be easy, I do it all the time in MS Access. I want to have an address book report which shows names, addresses, phone numbers, emails, etc.

The names and addresses are in the main contacts table, while the phones and emails are in their own tables, linked by relationships to the contacts table. Therefore, I will need a portal for each.

 

It should look something like:

 

A

Sam Adams Home: 888-888-8888

1234 Main St. Cell: 888-555-5555

Anytown, CA 99999 Email1: Sam@me.com

Email2: Me@you.com

 

Joe Anderson Home: 777-888-8999

2345 Main St. Work: 333-333-3333

MyTown, CA 33333 Email1: Joe@me.com

 

etc. etc.

 

Later I will attempt to make it multi-column so I get 2 columns on each page. for now, I need to figure out how to group this and do the portals so it comes out looking like the above example. It should group on the first letter of the last name.

 

Any ideas on how to do this? Thanks in advance.

Outcomes