troubleshooting Question

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

Avatar of AndyC1000
AndyC1000 asked on
Microsoft Access
1 Comment1 Solution197 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
als315

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros