I have a database of distributors, I have fields for address, shipping address and billing address. I want to print a master report with all the info for each distributor but I don't want the fields or fieldnames to print if there is in fact no info in those fields. How do I do this?

Create a query which has the criteria you wish e.g. is not null.

Cheers
Phil