Simple query(but not for me)

[satswid]

Hi,
Attached the db file.

I have a table with 4 columns
IDNO,Add1,Add2,LineNo



Values are

1 P T 1
1 O U 2
1 R G 3
2 E E 4
2 S N 5
2 E G 6
3 L H 7
3 I A 8
3 S P 9
4 O I 10
4 L C 11

Output required from query:
IDNO ADD

Values:
1 P
1 O
1 R
1 T
1 U
1 G
2 U
2 E
2 S
2 E

Please help

 

[Alansidman]

See Attached. Create two select queries and then join then in a UNION query.

 

[satswid]

See Attached. Create two select queries and then join then in a UNION query.

I did that however it gives output in the wrong manner

The output must be:

Values:
1 P -from Column1
1 O -from Column1
1 R -from Column1
1 T -from Column2
1 U -from Column2
1 G -from Column2
2 U -from Column1
2 E -from Column1
2 S -from Column1
2 E -from Column2
...
...
...

 

[student]

Can you clarify your table structure? I'd suggest the classic 'redo from start' if you have the choice...?

 

[Alansidman]

Access allows sorting with the following features:

• No Sort
• Ascending
• Descending

I don't believe that your requirements meet these logic criteria.