Results 1 to 3 of 3
  1. #1
    wajans is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    2

    How to make records of a table as column header and row header from

    Hello Everybody,


    How to make a column as column header and another column as row header in access. I have attached sample.png. I wanted to take Divisions as Column header and Categories as row headers and color as the data. Below is the sample output that I need:
    Catogery Division1 Division2 Division3


    Category1 Red Yellow Green
    Category2 Yellow Red Red
    Category3 Green Red Yellow
    Attached Thumbnails Attached Thumbnails sample.png  

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    I strongly recommend you do not cross post - please read this link for the reasons why

    http://www.excelguru.ca/content.php?184

    cross posted and answered here https://www.access-programmers.co.uk...d.php?t=291432

  3. #3
    wajans is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    2
    Thanks a lot for correcting me. I appreciate.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-15-2016, 08:45 AM
  2. Replies: 13
    Last Post: 06-13-2014, 03:25 PM
  3. Replies: 1
    Last Post: 04-06-2014, 10:58 AM
  4. Add a header row to CSV - not column names
    By shank in forum Import/Export Data
    Replies: 10
    Last Post: 09-27-2012, 02:29 PM
  5. Dates as Column Header
    By afvillodres in forum Queries
    Replies: 1
    Last Post: 07-24-2012, 06:04 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums