Report

[Udayan]

Dear Sir's

Pls any body help...........

I have a table with the flwg fields:-
Company Name (Comp-A, Comp-B, Comp-C etc.....)
Name of person
Rank

I have made seperate Query to show the presons which is working on each
company. ie., (QryCompanyA, QryCompanyB, QryComapyC)

Is there any way to give all Query result or a report all in one page like
below with the company heading, if so how?

Company-A
-------------
Person1
Person2
Person3

Company-B
-------------
Person1
Person2
Person3

Company-C
-------------
Person1
Person2
Person3

Thanks in Advance....

 

[Philip Herlihy]

Dear Sir's

Pls any body help...........

I have a table with the flwg fields:-
Company Name (Comp-A, Comp-B, Comp-C etc.....)
Name of person
Rank

I have made seperate Query to show the presons which is working on each
company. ie., (QryCompanyA, QryCompanyB, QryComapyC)

Is there any way to give all Query result or a report all in one page like
below with the company heading, if so how?

Company-A
-------------
Person1
Person2
Person3

Company-B
-------------
Person1
Person2
Person3

Company-C
-------------
Person1
Person2
Person3

Thanks in Advance....

Rule 1: Make sure your table structure is right. You should normally
have separate tables for Company and Person, including the Company-ID in
the details for a Person. Set up a Relationship in Access using the
"Relationships" window. However, if you're never going to need to store
more than minimal Company information (not even an address?) then a
single Person table could suffice. This video might be helpful:
http://www.lynda.com/home/Player.aspx?lpk4=13150

Then create a query which brings together all the details you want in
your report, and use the Report Wizard to base a new report on that
query. When asked if you want any Grouping, pick the Company field.

That should do it. When you have the first version of the report,
open it in design view and have a look at the grouping options set using
the "Sorting and Grouping" button on the toolbar (looks like a Space
Invader on its side!).

Phil, London