column heading for crosstab

[Annelie]

Trying to use a crosstab query on a form and it tells me that I have to set
the column headings, I am assuming to a fix number of columns.
My Columns represent the days of the week: Monday thru Sunday, I guess so
that the date on the form automatically goes to the right day of the week.

How and where do I enter these days for the heading?

 

[Rick Brandt]

Trying to use a crosstab query on a form and it tells me that I have to set
the column headings, I am assuming to a fix number of columns.
My Columns represent the days of the week: Monday thru Sunday, I guess so
that the date on the form automatically goes to the right day of the week.

How and where do I enter these days for the heading?

Open your Crosstab query in design view and put your cursor in the column of the grid
that has "Column Heading" as the Crosstab entry. Then click on the toolbar button
that displays the property sheet (if it's not already displayed). In the property
sheet you should now see a property called "Column Headings".