Creating 'the yellow pages"

  • Thread starter Thread starter dana
  • Start date Start date
D

dana

We need to develop a 'yellow pages' type index (report)
for this manufacturing company directory. I have over
200 companies in the database which may manufacture more
than one product. We would like to sort them by their
product/service, but (like the yellow pages) they may fit
into more than one product catagory. Please Help.
 
dana said:
We need to develop a 'yellow pages' type index (report)
for this manufacturing company directory. I have over
200 companies in the database which may manufacture more
than one product. We would like to sort them by their
product/service, but (like the yellow pages) they may fit
into more than one product catagory. Please Help.
Click to expand...

A simple query relating the company with their service(s) will give you the
list you want.
After than it is just report designs, grouping and sorting. The wizard will
guide you through it.
One report would be grouped on the service and sorted on the company name.
Another would "group" on the company name and sort by services.

This might lead to a larger report than desired if most companies have only
one service.

Company with more than one
service
service
service
Company with just one Service

would save space and be the only place some code was required.
 
Back
Top