RE: Joining different parts of the same table

Tech-Archive recommends: Speed Up your PC by fixing your registry

While trying to make my example clear, I think I made it confusing. In the
real world, Table A contains an Item_# field made up of yyyy-q-nnn
data("2008-1-001", "2008-2-001","2009-2-002", etc). The Description field is
just a text field. The resulting table should contain
"2009-2-002","2008-2-001","2008-1-001", etc.

The source table contains:
"Group 1","Group 1 description"
"Group 2","Group 2 description"
"2008-1-001","2008 item-quarter 1-part 001"
"2008-2-001","2008 item-quarter 2-part 001"
"2009-2-002","2009 item-quarter 2-item 002"
"2009-2-003","2009 item-quarter 2-item 003"

The resulting table should contain
"2009-2-003","2009 item-quarter 2-part 003"
"2009-2-002","2009 item-quarter 2-part 002"
"2008-2-001","2008 item-quarter 2-part 001"
"2008-1-001","2008 item-quarter 1-part 001"
"Group 1","Group 1 description"
"Group 2","Group 2 description"

I hope this clears up my example. I tried the suggested approaches without
success.

"Goldar" wrote:

I have a table (Table A) that contains Item_# and Description fields. I want
to create another table that contains all of the Table A records whose first
character of Item_# is numeric followed by all of the Table A records whose
first character of Item_# is alphabetic. The resulting table should contain
the numeric records in decending sequence and the alphabetic records in
ascending sequence. How can I structure a query to do this?

Resulting table example sequence:
4
3
2
1
A
B
C
D


Thanks

.

Relevant Pages