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

thanx A.D.

I'll try it out, and let you know.

alun

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of A.D.Tejpal
Sent: Thursday, January 22, 2004 5:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com