Results 1 to 2 of 2
  1. #1
    MSAnoob is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2022
    Posts
    2

    Create report with records presented as columns and fields as rows

    Hello, I have a table with property P&L data and have created a query with all 2021 numbers. When I create a report using the wizard, I get a single record per page, whereas I need a table with all records next to each other as per image below. I don't know any SQL, but if it is necessary and not too complex, happy to use. Thanks!



    Click image for larger version. 

Name:	2022-09-23_22-54-17.png 
Views:	16 
Size:	27.8 KB 
ID:	48797


  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You can base a report on a cross tab query to get a result like that. However, if it is possible that some times there might not be data for a particular column you have to take steps to ensure the column is still represented in the report.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Move columns to rows (fields to records)
    By Leonel in forum Queries
    Replies: 5
    Last Post: 04-09-2018, 02:54 PM
  2. Replies: 6
    Last Post: 02-14-2015, 05:40 PM
  3. Replies: 5
    Last Post: 10-28-2013, 10:04 PM
  4. Replies: 1
    Last Post: 07-30-2013, 06:33 AM
  5. Replies: 1
    Last Post: 05-14-2012, 04:12 AM

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