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

Convert Column Dates to Rows

P: 1
Hi

In Access 2010, is there a method to convert my data set so rather than the dates being columns as they are now, I would like to change them to rows. i.e.

From

Jan-10 Feb-10 Mar-10
50 74 80

To

Jan-10 50
Feb-10 74
Mar-10 80

Any help with this would be appreciated!

thanks

Chris
Nov 25 '11 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,707
A UNION query would probably do it (The info in the question is pretty sparse so we're working on fumes here).

Expand|Select|Wrap|Line Numbers
  1. SELECT [Field1]
  2. FROM   [Table]
  3. UNION ALL
  4. SELECT [Field2]
  5. FROM   [Table]
  6. ...
Nov 25 '11 #2

Post your reply

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