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

Data Transposition

P: n/a


I'd prefer not to type 100 field names for a union query, so I was
wondering what code methods are available to do something like the
following:

A B C
1 2 3

to:
Var Value
A 1
B 2
C 3

I posted an earlier message, but I cannot tell if it actually happened.

Thx...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.