I do not need the second column heading, just to clarify my point.

To do that in Access, your crosstab query has to create separate columns such as Jan-2023 Sessions, Jan-2023 Attended, Feb-2023 Sessions, Feb-2023 Attended, and so on.  There is no way to have a column header that "merges" two columns.  In Excel, you can merge cells, but not in Access.

Good morning Kevin

Thank you for responding. I actually want to do what you suggested. I am not warried about cell merge of the collum headings. I just cannot finger out how to get two columns in the query.

something like this (see below)

To make it appear like in your picture, the values "Session 1", "Attended 1", etc. must already exist in your query, either from table values or calculated field values.  Also, a crosstab query always sorts column headers alphabetically.  Your column headers would appear as Attended 1, Attended 2, ... Session 1, Session 2, etc.  To sort them the way you want, you need to go into that field's property window in the query design screen (see picture below) and manually enter the order of the values.  This could be a problem if your column headers were dynamically generated (i.e. values changing every time).

Thank you Kevin

That is very helpful

Sami, first off let me say I haven't worked with crosstab, other than the courses, EVER.  So... I'm just trying to help you think outside the box.

What if you create a query and concatenate the session and attended together to get the column value?
So something like DisplayValue: [Sessions] & " -- " & [Attendance]

Another alternative might be to create a TempTable to generate the data and use Excel to format and display your data as it seems to have a better functionality for crosstab and pivot tables.
You might even be able to display the Excel in your db as say a subform in a form.

Again - I haven't tried any of this - I'm just trying to help you think through your issue.