Show categories on top rather than on side

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
Is the problem in the query or report?

If it is in the query then post your SQL statement.
 
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;
 
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...
 
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...
 
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...
 
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...
 
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...
 

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

Similar Threads

Lookup with multiple matches 2
combine 'same' data in 2 fields in report 2
Sub-report problem 2
Report for Max, Ave & Detail Record for Highest Sale Price by Cate 1
Mech. Keyboard & Ultrathin Bezel Display – AORUS 17 Ultimate Gaming Laptop 3
Word prints some letters on top of each other 0
Help needed - want to count categories within a category on a repo 5
Manipulating Command box in a access report in detail section 2

Back
Top