[AccessD] changing data from "Crosstab" to "Normal" tbl view?

Garraway, Alun Alun.Garraway at otto.de
Thu Jan 22 05:12:56 CST 2004


hi,

I have a tbl that looks like a spreedsheet, the table looks like this:

ART_NR	W1	W2	W3	W4	.... W30
110		10	8	12	14
258		20	16	22	13

what I want to do is "normalize" the data like this:

ART_NR	WEEK		ORDERS
110		1		10
110		2		8
110		3		12
110		4		14
258		1		20
258		2		16
etc

is that possible (with sql), I can't think of anything :-(

alun



More information about the AccessD mailing list