|
| |
|
|
helensnow
Posts: 228
Joined: 12/18/2003
Status: offline
 |
Special Sorting of Columns - 11/23/2007 9:04:04
I got a mixed bag of results searching the archieves, so let me ask the question!
I have to pull some data from a table.
This table has 2 columns, columnA and columnB
The values are as follows
ColumnA ColumnB
1.............. 2
3.............. 4
5.............. 6
7.............. 8
9.............. 10
Can I do a sort that produces a result that goes like this
1
2
3
4
5
6
....
Ordinarily these values would be in different tables and an Inner Join would /sort would give me the answer, but a previous design flaw has caused this issue
I am using Access 2007
Thanks
Helen Snow
< Message edited by helensnow -- 11/23/2007 10:00:19 >
_____________________________
Love is all, and all that we are is love
|
|
|
|
William Lee
Posts: 1179
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Special Sorting of Columns - 11/23/2007 22:15:47
Yes, use UNION as suggested by Spooky.
Select ColumnA from Table
UNION
Select CoumnB from Table
ORDER BY 1 ASC
< Message edited by William Lee -- 11/24/2007 0:17:00 >
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 