• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

Query reformat table, how to convert table contents to header field

Dear all,

The title of my question might be confusing. I'm trying to convert the values in the Dates column to headers, populating its contents with the values data.   See below tables.  I won't know the contents of Dates, its type is Data/Time. Is this possible?


Output.png
Thanks
0
AndyC1000
Asked:
AndyC1000
1 Solution
 
als315Commented:
You can use Crosstab query:
TRANSFORM Sum(Table1.Values) AS SumOfValues
SELECT Table1.Name
FROM Table1
GROUP BY Table1.Name
PIVOT Table1.Dates;

Open in new window

In designer:
crosstab
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now