By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Want to view query output in horizontal table

P: 2
i get the output of the query as

Jan 0.1
Feb 1

I Want to view data in the following format

Jan Feb Mar
0.1 1 2

Can any please help me?

Thanks in advance,

Feb 13 '08 #1
Share this Question
Share on Google+
1 Reply

P: 83

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.

Feb 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.