Access Crosstab

Question

Hi! I have created a Crosstab Query in Access and would like to change what the column headings display. In the screenshot below, in the column headings 1, 2, and 3, I would like it to display - "1 Hour Sessions", "2 Hour Sessions", "3 Hour Sessions". The 1,2,3 indicates the Length (in hours) from the Length field

Can anybody explain how to do this? I have tried every IIF function and nothing is working. TY - I appreciate any input!

Answer 1

That's the problem with Input Masks. Personally, I find them more hassle than help and don't use them.

Answer 2

Thank You!

I hope you don't mind but I have another question (Obviously I am very new to Access!)

In regard to phone numbers using Input Mask - I want to create it with only the last seven digits required. My Input Mask is !999.000.0000;;_ which results in 555.555.5555. When I try to just enter the last seven digits it auto populates to the area code field, doesn't allow me to just enter 555.5555 and the error is "The value you entered isn't appropriate for the input mask !999.000.0000;; specified for this field."

Any suggestions?

Thank You!

Answer 3

Congratulations on solving the problem.

Continued success with the project.

Answer 4

OMG! Genius! I didn't even have to change the property sheet.

I was trying to change the Column Heading column of the crosstab and change the Column Headings in the property sheet but I was not putting it in the correct format of Expr1: [Length] & " Hour Sessions".

Thank You so Much!

Answer 5

In the Column Heading column of the crosstab, concatenate the text values you want to see: [YourFieldNameGoesHere] & " Hour Sessions".

Look at the query's property sheet. Find the "Column Headings" property. Enter the names you want, 1 Hour Sessions, etc. . Those columns will appear in the crosstab.