troubleshooting Question

Query to change format of table - field value to columns (new fields)

Avatar of AndyC1000
AndyC1000 asked on
Microsoft Access
4 Comments1 Solution467 ViewsLast Modified:
Dear all,

I have a table in the below format:

M      Y      District      Role      CountOfRole
1      2010      18      Admin      1
1      2010      19      IT      1
2      2010      18      Admin      2
2      2010      19      IT      1


I need to change the format to:

M      Y      District      Admin      IT
1      2010      18      2      1
2      2010      19      1      1

Is this possible in a query? Apologies for the alignment of example data.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
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 4 Comments.
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