Change column headings in crosstab querry

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I created a crosstab query and I want to change two of the column headings.
The column Headings are to be Number of 30-minute lessons and Number of
60-minute lessons. My LessonLength column is where I am getting the
information from.

Here is what I have tried and doesn't work.
IIF(LessonLength, "Number of 30-Minute Lessons" , "Number of 60-Minute
Lessons")

The LessonLength Column gives both 30 or 60. How do I create the two
columns so that all of the 30 minute lessons are in one column and 60 minute
are in another with the headings from above.

Any help would be greatly appreciated. This is due Thursday.

Thanks
 
In Query design, in the design grid in the lower part of the window, enter
this in the "Field" row:

"Number of " & [LessonLength] & "-Minute Lessons"

....then tab/enter to the next "cell". Access will probably autocorrect to:

Expr1: "Number of " & [LessonLength] & "-Minute Lessons"

Now, in that same "column", make sure the "Crosstab:" cell/row reads "Column
Heading"

HTH,

Conan
 
Back
Top