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




"Joyce" <Joyce@discussions.microsoft.com> wrote in message 
news:95011B65-F187-4775-B69C-FAB158B95804@microsoft.com...
>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
>