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

Alun,

    You might like to take a look at my sample database named  CrossTabAndReverse  at RogersAccessLibrary (Other Developers Section). It covers the functionality needed by you.

Regards,
A.D.Tejpal
--------------
  ----- Original Message ----- 
  From: Garraway, Alun 
  To: Access DatabaseAdvisors (E-Mail) 
  Sent: Thursday, January 22, 2004 16:42
  Subject: [AccessD] changing data from "Crosstab" to "Normal" tbl view?


  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