Morning...I need some help with my report in ms access 2007. I have 2 different issues:

1. I need to combine records in my report. For example I have 5 employees contact information but instead of having the company name listed only once with the names of all 5 employees listed under it, I have the company listed 5 times with only one employee beneath it. How do I put all names under one heading.

2. I need to be able to add in a simple restriction to allow information like the phone, fax, email, etc. to show only if there is information there.

Any help you can provide will be appreciated. Thanks!