Cross Tab Query with no values

I have a table with 3 columns:

Name (type: Text)
Item Name (type: Text)
Due Date (type: Date)

How can I have a crosstab type query that has "Name" as the first column, "Due Date" as columns across the top, and "Item Name" triangulated at the intersection of "Name" and "Due Date".  I could not get this to work partially because there are no data fields.
legendtooAsked:
Who is Participating?
 
GRayLConnect With a Mentor Commented:
TRANSFORM First([Item Name])
SELECT [Name]
FROM myTable
GROUP BY [Name]
PIVOT [Due Date];
0
 
Jeffrey CoachmanMIS LiasonCommented:
Please post a sample of your table data.
Also post an example of the exact output you are expecting.

I am sure an Expert will be along shortly to help.

;-)

JeffCoachman
0
 
GRayLCommented:
I wonder why you did not think it necessary to include the table name ;-)  Of course you will substitute your actual table name for myTable.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
legendtooAuthor Commented:
Sorry....Table name is "Projects"

Fields:
Name (type: Text)
Item Name (type: Text)
Due Date (type: Date)

Name   |      Item Name     |      Due Date
John          Project 1                9/1/11
Dave          Project 2               9/2/11
Sam           Project 3                9/5/11
John          Project 4                9/4/11

Output:

Name         |          9/1         |          9/2        |           9/3         |          9/4          |           9/5          |
John                 Project 1                                                           Project 4                
Dave                                        Project 2
Sam                                                                                                                      Project 3
0
 
legendtooAuthor Commented:
Thanks GRayL !!!!  It works !!!

Now, can I Transform more than one field?  Would I replace "First" with "Second" ?  I tried it as an experiment but it failed so there must be another method to Transform more than one field.

Thanks Again!!!!
0
 
GRayLCommented:
This looks like a different question.  I don't know what you mean by - can I Transform more than one field? -  If you decide to post a new question, be sure to include an example of what you have - transformed into what you want to see.   Post a link to the new question back here.
0
 
legendtooAuthor Commented:
Thanks....I posted a new question.
0
 
GRayLCommented:
Can you copy the address of the new question and paste it a comment back here.  I don't see it yet.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.