Phone list reports - Multiple categories

  • Thread starter Scott Whetsell, A.S. - WVSP
  • Start date
S

Scott Whetsell, A.S. - WVSP

I need to print a phone list from access which will list all the entries in
alphabetical order, but will also add additional entries for each company
that the people work for as an entry itself and list the employees under the
entry.

ex:

I enter:

Name Phone Company Phone
John Doe 555-1234 ABC Corp 555-4321
Jane Doe 555-9876 XYZ Corp 555-6789
ABC Corp 555-4320
XYZ Corp 555-6780

I get on my report:

ABC Corp 555-4320
John Doe 555-4321 555-1234

Jane Doe 555-9876 XYZ Corp 555-6789

John Doe 555-1234 ABC Corp 555-4321

XYZ Corp 555-6780
Jane Doe 555-6789 555-9876

=====

Does anyone have any ideas how I can accomplish this? Any help is
appreciated.
 
B

_Bigred

"Scott Whetsell, A.S. - WVSP"
I need to print a phone list from access which will list all the entries in
alphabetical order, but will also add additional entries for each company
that the people work for as an entry itself and list the employees under
the
entry.

ex:

I enter:

Name Phone Company Phone
John Doe 555-1234 ABC Corp 555-4321
Jane Doe 555-9876 XYZ Corp 555-6789
ABC Corp 555-4320
XYZ Corp 555-6780

I get on my report:

ABC Corp 555-4320
John Doe 555-4321 555-1234

Jane Doe 555-9876 XYZ Corp 555-6789

John Doe 555-1234 ABC Corp 555-4321

XYZ Corp 555-6780
Jane Doe 555-6789 555-9876

=====

Does anyone have any ideas how I can accomplish this? Any help is
appreciated.

I would probably create your report based on table or report, then set your
grouping/sorting to Group (i.e. company). then you can set the other sort
fields after the grouping value.

hope this helps, if not post back and I'll see what I can further describe.

_Bigred
 
K

Kernow Girl

Hi Scott - it looks like you need to 'group' on both company and employees.
In Design View for your report find the Sorting and Grouping Icon and make
sure both are there. Yours - Dika
 
S

Scott Whetsell, A.S. - WVSP

Grouping like that I was able to set first level headers for the companies
with the employees grouped under the company, but I cannot get the employees
to be listed also as first level headers.
 
K

Kernow Girl

Scott - What about 2 sub-reports?

Scott Whetsell said:
Grouping like that I was able to set first level headers for the companies
with the employees grouped under the company, but I cannot get the employees
to be listed also as first level headers.
 

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