Results 1 to 5 of 5
  1. #1
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408

    Crosstab query with "subcolumns"

    Hi, i have the datas in first image, and i want to get an output as in the second image. Is it possible with a crosstab query? thanks


    my data

    Click image for larger version. 

Name:	Immagine1.png 
Views:	21 
Size:	7.7 KB 
ID:	49528

    output



    Click image for larger version. 

Name:	Immagine2.png 
Views:	21 
Size:	8.3 KB 
ID:	49529

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Possibly but you would be required to provide the headers since a) cross tabs only have one header row and b) you requirement had duplicate column headings in the second row- I don’t see how the values relate so can’t comment further.

    Explain clearly what the calculation actually is - where do the values for BL come from and what differentiates the two lines?

  3. #3
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    thank you, but i realized that i need a report, not a crosstab query.
    thank you for the answer and sorry, i never tried a crosstab before

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    a report is still based off a query

  5. #5
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    Sure, but the problem is display of data more than data itself...

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

Similar Threads

  1. Replies: 8
    Last Post: 11-22-2022, 05:40 AM
  2. Replies: 5
    Last Post: 04-08-2021, 09:15 AM
  3. Need "0" in crosstab query (for empty cells)
    By skydivetom in forum Queries
    Replies: 4
    Last Post: 03-02-2020, 02:31 PM
  4. Replies: 3
    Last Post: 12-30-2016, 03:55 PM
  5. Replies: 1
    Last Post: 09-07-2015, 08:00 AM

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