Not able to add more column heading in cross tab query. its urgent plz help...

[RunLikeaRiver]

Hi,

Not able to add more column heading in cross tab query.
I tried to change the query properties to add more column headings as given below.
In the query's Design view, right-click up in the area where your tables are shown and choose "Properties" from the right-click menu. The 3rd line down is for Column names. Enter what you need there.

Evn after doing it. i am not able to .
Whn I try to save or view the datasheet it says. to create a crosstab query u need to have one or more row headin one column headin and one value.

please help. its ver urgent.
thanks in adv..

 

[Jon K]

Use the Crosstab Query Wizard (in the Queries tab, click New) to build the crosstab query first. Then you can use the method that you described to specify/limit the column headings to be displayed.
.