Difficult SQL Query with multiple records detail

[Flash]

I am trying to turn a list of data that looks like this:
ID A B C
---- ---- ---- ----
1 0 1 3
2 1 2 1

Into a result set that looks like this on a report:
ID Product Qty
---- ----------- -----
1 B 1
1 B 3
2 A 1
2 A 2
2 A 1

Is this possible? If so, how would I do it? I would prefer not having
to use VB, I would rather solve this in SQL/Queries alone.

Using Access 2000 or SQL Server 2000

Marco

[Danny J. Lesandrini]

Try this ...

SELECT tblData.ID, 'A' AS Type, [A] As Value
UNION
SELECT tblData.ID, 'B' AS Type, [b] As Value
UNION
SELECT tblData.ID, 'C' AS Type, [C] As Value
ORDER BY ID, Type, Value

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Flash" <ma***********@merial.com> wrote ...

I am trying to turn a list of data that looks like this:
ID A B C
---- ---- ---- ----
1 0 1 3
2 1 2 1

Into a result set that looks like this on a report:
ID Product Qty
---- ----------- -----
1 B 1
1 B 3
2 A 1
2 A 2
2 A 1

Is this possible? If so, how would I do it? I would prefer not having
to use VB, I would rather solve this in SQL/Queries alone.

Using Access 2000 or SQL Server 2000

Marco

[Danny J. Lesandrini]

Actually, this is more like it ...

SELECT tblData.ID, 'A' AS Product, tblData.[A] As Qty
UNION
SELECT tblData.ID, 'B' AS Product, tblData.[b] As Qty
UNION
SELECT tblData.ID, 'C' AS Product, tblData.[C] As Qty
ORDER BY ID, Product, Qty

--

[Flash]

Thank you
That's what I was looking for.

Danny J. Lesandrini wrote:

Actually, this is more like it ...

SELECT tblData.ID, 'A' AS Product, tblData.[A] As Qty
UNION
SELECT tblData.ID, 'B' AS Product, tblData.[b] As Qty
UNION
SELECT tblData.ID, 'C' AS Product, tblData.[C] As Qty
ORDER BY ID, Product, Qty

--