Want to view query output in horizontal table

[RamyaKarri]

i get the output of the query as

Jan 0.1
Feb 1
MAR 2
..

I Want to view data in the following format

Jan Feb Mar
0.1 1 2


Can any please help me?

Thanks in advance,

Ramya

[cori25]

Hello...

If you want to view the data horizontally, you will have to create a crosstab query. You will need 1 column heading, 1 value and infinite rows.(You do not have to show any rows)

Therefore, you will need the month field as the column heading, and the values you have shown as a value in the crosstab selection. *Reminder* You must select whether you want the value to appear as a sum, count etc... in the GroupBy selection.

This will give you the results you are looking for.

Thanks