Results 1 to 3 of 3
  1. #1
    gwalshe is offline Novice
    Windows 11 Access 2019
    Join Date
    Nov 2022
    Posts
    1

    Report with headings on the left and data in columns to the right

    How do you create a budget type report with headings on the left and data in columns to the right. For example organised by year and then month



    2022 2023
    1 2 3 4 5 6 7 8 9 10 11 12 Total 1 2
    Coffee 57 47 28 77 84 13 44 46 49 88 33 84 650 44 46
    Tea 12 45 27 18 36 31 39 12 48 66 12 4 350 39 12
    Donuts 45 99 125 120 88 75 72 68 144 136 155 111 1238 72 68
    Cake 37 80 66 70 48 39 45 54 44 99 111 45 738 45 54



    Thanks

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    How is your data structured?

    Would expect you to be using a crosstab query - but suspect this needs to be dynamic since the headings change

    For it to work you would need to set the headings with a calculated value such as

    2022-01, 2022-02 etc

    which is easy to achieve using the format function

    colHdr: format(myDate,"yyyy-mm")

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-17-2021, 09:48 AM
  2. Replies: 10
    Last Post: 11-01-2016, 07:06 AM
  3. Replies: 3
    Last Post: 04-15-2016, 12:19 PM
  4. Replies: 1
    Last Post: 10-12-2015, 06:51 PM
  5. Headings Across the Report
    By Lupson2011 in forum Reports
    Replies: 4
    Last Post: 02-16-2012, 06:29 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