Create button to display data?

[alicias4]

I have a report which is based on a query, based on a relational database.



It shows the Company Name, Product and then the Address (Street, City, State, ZIP)
I have the report sorted by Company name, then it lists the products and the address.

I would either like the address (which is 4 separate columns noted above) to appear once underneath or beside the company name, and then list the products.

OR To have the company name show up on a button or something that when I click on it, it brings up the address information. (This is the method that I think would LOOK the best)

Is there a way to accomplish this? Or am I stuck with the repeating addresses> (If a company has 10 products, it lists the address 10 times... looks very chaotic)

Thanks in advance!

[pbaldy]

Sounds like you want to group on company, and have those fields in the group header. The report wizard should at least start that for ou.