Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Cross Tab Query with no values

Posted on 2011-03-20
8
296 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:legendtoo
  • 4
  • 3
8 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35175623
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
 
LVL 44

Accepted Solution

by:
GRayL earned 250 total points
ID: 35176109
TRANSFORM First([Item Name])
SELECT [Name]
FROM myTable
GROUP BY [Name]
PIVOT [Due Date];
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35176115
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:legendtoo
ID: 35193635
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
 

Author Comment

by:legendtoo
ID: 35194611
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
 
LVL 44

Expert Comment

by:GRayL
ID: 35199353
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
 

Author Comment

by:legendtoo
ID: 35199933
Thanks....I posted a new question.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35200248
Can you copy the address of the new question and paste it a comment back here.  I don't see it yet.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question