Show categories on top rather than on side

M

MRG

From a query of my contacts I generate a report showing Committee, Name,
Organization, and category. How do I design it to show the 14 Committees
along the top, Organization on the left hand side and then the names and
their category is the detailed information. The number of people changes
often so I am frequently replacing the list. Any assistance is very much
appreciated.
 
K

KARL DEWEY

Is the problem in the query or report?

If it is in the query then post your SQL statement.
 
M

MRG

It seems to be in the x-tab query. The originanl query gets the information
from two different tables, and all the information shows in that query. SQL
statement from the x-tab is below:

TRANSFORM First([Task Group Summary Query AT 4].FullName) AS FirstOfFullName
SELECT [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
PIVOT [Task Group Summary Query AT 4].Name;
 
K

KARL DEWEY

Committee, Name, Organization, and category. How do I design it to show
the 14 Committees along the top, Organization on the left hand side and then
the names and their category is the detailed information.

I built a table for a source of your query but the fields - Jurisdiction,
Category, and name do not match Committee and Organization. Something is
lost along the way.


MRG said:
It seems to be in the x-tab query. The originanl query gets the information
from two different tables, and all the information shows in that query. SQL
statement from the x-tab is below:

TRANSFORM First([Task Group Summary Query AT 4].FullName) AS FirstOfFullName
SELECT [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
PIVOT [Task Group Summary Query AT 4].Name;


KARL DEWEY said:
Is the problem in the query or report?

If it is in the query then post your SQL statement.
Click to expand...
Click to expand...
 
M

MRG

Sorry about that. For Organization read Jurisdiction; for Committee read
Name.

KARL DEWEY said:
the 14 Committees along the top, Organization on the left hand side and then
the names and their category is the detailed information.

I built a table for a source of your query but the fields - Jurisdiction,
Category, and name do not match Committee and Organization. Something is
lost along the way.


MRG said:
It seems to be in the x-tab query. The originanl query gets the information
from two different tables, and all the information shows in that query. SQL
statement from the x-tab is below:

TRANSFORM First([Task Group Summary Query AT 4].FullName) AS FirstOfFullName
SELECT [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
PIVOT [Task Group Summary Query AT 4].Name;


KARL DEWEY said:
Is the problem in the query or report?

If it is in the query then post your SQL statement.

:

Worked just fine, except that for the one committee that has several people
from one category only one person appears. How do I get it to show multiple
names?

:

Use a crosstab query.

:

From a query of my contacts I generate a report showing Committee, Name,
Organization, and category. How do I design it to show the 14 Committees
along the top, Organization on the left hand side and then the names and
their category is the detailed information. The number of people changes
often so I am frequently replacing the list. Any assistance is very much
appreciated.
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

TRANSFORM First([FullName] & " - " & [Category]) AS Expr1
SELECT [Task Group Summary Query AT 4].Jurisdiction AS Organization
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction
PIVOT [Task Group Summary Query AT 4].Name;


MRG said:
Sorry about that. For Organization read Jurisdiction; for Committee read
Name.

KARL DEWEY said:
Committee, Name, Organization, and category. How do I design it to show
Click to expand...
the 14 Committees along the top, Organization on the left hand side and then
the names and their category is the detailed information.

I built a table for a source of your query but the fields - Jurisdiction,
Category, and name do not match Committee and Organization. Something is
lost along the way.


MRG said:
It seems to be in the x-tab query. The originanl query gets the information
from two different tables, and all the information shows in that query. SQL
statement from the x-tab is below:

TRANSFORM First([Task Group Summary Query AT 4].FullName) AS FirstOfFullName
SELECT [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
PIVOT [Task Group Summary Query AT 4].Name;


:

Is the problem in the query or report?

If it is in the query then post your SQL statement.

:

Worked just fine, except that for the one committee that has several people
from one category only one person appears. How do I get it to show multiple
names?

:

Use a crosstab query.

:

From a query of my contacts I generate a report showing Committee, Name,
Organization, and category. How do I design it to show the 14 Committees
along the top, Organization on the left hand side and then the names and
their category is the detailed information. The number of people changes
often so I am frequently replacing the list. Any assistance is very much
appreciated.
Click to expand...
Click to expand...
Click to expand...
 
M

MRG

Thanks. This was very helpful. Is it possible in the first line of the
expression to change First to All, in order to list everyone, not just the
first person?

KARL DEWEY said:
TRANSFORM First([FullName] & " - " & [Category]) AS Expr1
SELECT [Task Group Summary Query AT 4].Jurisdiction AS Organization
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction
PIVOT [Task Group Summary Query AT 4].Name;


MRG said:
Sorry about that. For Organization read Jurisdiction; for Committee read
Name.

KARL DEWEY said:
Committee, Name, Organization, and category. How do I design it to show
the 14 Committees along the top, Organization on the left hand side and then
the names and their category is the detailed information.

I built a table for a source of your query but the fields - Jurisdiction,
Category, and name do not match Committee and Organization. Something is
lost along the way.


:

It seems to be in the x-tab query. The originanl query gets the information
from two different tables, and all the information shows in that query. SQL
statement from the x-tab is below:

TRANSFORM First([Task Group Summary Query AT 4].FullName) AS FirstOfFullName
SELECT [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
PIVOT [Task Group Summary Query AT 4].Name;


:

Is the problem in the query or report?

If it is in the query then post your SQL statement.

:

Worked just fine, except that for the one committee that has several people
from one category only one person appears. How do I get it to show multiple
names?

:

Use a crosstab query.

:

From a query of my contacts I generate a report showing Committee, Name,
Organization, and category. How do I design it to show the 14 Committees
along the top, Organization on the left hand side and then the names and
their category is the detailed information. The number of people changes
often so I am frequently replacing the list. Any assistance is very much
appreciated.
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Try this --
TRANSFORM First([FullName] & " - " & [Category]) AS Expr1
SELECT [Task Group Summary Query AT 4].Jurisdiction AS Organization
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].FullName, [Task Group Summary Query
AT 4].Jurisdiction
PIVOT [Task Group Summary Query AT 4].Name;


MRG said:
Thanks. This was very helpful. Is it possible in the first line of the
expression to change First to All, in order to list everyone, not just the
first person?

KARL DEWEY said:
TRANSFORM First([FullName] & " - " & [Category]) AS Expr1
SELECT [Task Group Summary Query AT 4].Jurisdiction AS Organization
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction
PIVOT [Task Group Summary Query AT 4].Name;


MRG said:
Sorry about that. For Organization read Jurisdiction; for Committee read
Name.

:

Committee, Name, Organization, and category. How do I design it to show
the 14 Committees along the top, Organization on the left hand side and then
the names and their category is the detailed information.

I built a table for a source of your query but the fields - Jurisdiction,
Category, and name do not match Committee and Organization. Something is
lost along the way.


:

It seems to be in the x-tab query. The originanl query gets the information
from two different tables, and all the information shows in that query. SQL
statement from the x-tab is below:

TRANSFORM First([Task Group Summary Query AT 4].FullName) AS FirstOfFullName
SELECT [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
FROM [Task Group Summary Query AT 4]
GROUP BY [Task Group Summary Query AT 4].Jurisdiction, [Task Group Summary
Query AT 4].Category
PIVOT [Task Group Summary Query AT 4].Name;


:

Is the problem in the query or report?

If it is in the query then post your SQL statement.

:

Worked just fine, except that for the one committee that has several people
from one category only one person appears. How do I get it to show multiple
names?

:

Use a crosstab query.

:

From a query of my contacts I generate a report showing Committee, Name,
Organization, and category. How do I design it to show the 14 Committees
along the top, Organization on the left hand side and then the names and
their category is the detailed information. The number of people changes
often so I am frequently replacing the list. Any assistance is very much
appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Top