Not sure how to make a grouped report

Z

ZakAdelman

I have a list of 465+ companies each with 1-4 contacts. The DB is setup in a
way where each contact is listed with their company, address, phone, etc...
Now I want to be able to make a report where it will have a listing like this

Company
Address
City ST Zip
etc...
Contact1 Contact2
Contact3 Contact4

I am not sure if this is possible but I wanted to see if anyone here knew.
 
R

Rick B

Just use grouping and sorting and group by company. Turn on the group
header option.

Place all the company data in the group header.

In the detail section, put your contact data. I think you can set it up as
two columns, but if not, it would look like the following:

Company Name
Address
etc.
contact1
contact2
contact3
contact4

Company Name
Address
etc.
contact1
contact2

Company Name
Address
etc.
contact1
contact2
contact3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top