multiple data from same entrie

[Dimitris]

Dear all hi,
Firt time posting here and new with access.

i have the foll to ask: have a table from which i need to take in a query 2 fields into 2 seperated rows
example: my table has fields..seller-supplier1-Quantity1-Supplier2-Quantity2.
in every query i've tried i get one row with both quantity1 & quantity2
How can i get 1 row for Quantity1 and another row for Quantity2?
Is it possible?

sorry if this posted before but I'm in big hurry (and big trouble if dont find solution)
Tks in advance
D.

 

[ByteMyzer]

You might try something like the following UNION query (substitute highlighted text with appropriate table/field names):

SELECT T1.[B][I]Seller[/I][/B], 1 AS [Row],
       T1.[B][I]Supplier1[/I][/B] AS [Supplier], T1.[B][I]Quantity1[/I][/B] AS [Quantity]
FROM [B][I]MyTable[/I][/B] T1
UNION SELECT T2.[B][I]Seller[/I][/B], 2, T2.[B][I]Supplier2[/I][/B], T2.[B][I]Quantity2[/I][/B]
FROM [B][I]MyTable[/I][/B] T2;

 

[Dimitris]

tx for the reply.
will try it.

 

[Dimitris]

it works perfect into the example. Thanks a lot ByteMyzer.
Now i have to make it work into a complex query that i have. If dont make it i know who to ask

Tks again

 

[ByteMyzer]

You're welcome, I'm glad it worked for you