Avatar of yasanthax
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Access cross tab query used for column relationships


I am looking for a solution  to look at relationships between matching columns on a records set (see below).  This  maybe a data manipulation question but I do think I have used an Access cross tab similarly in the past.  Can this be done through a Access cross tab and if so how?

Data input                        
            Role 1      Role 2      Role 3
      Process 1      x            x
      Process 2            x      
Desired output            Role 1      Role 2      Role 3
      Role 1      x            x
      Role 2            x      
      Role 3      x            x
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon