P
plgerh
Hi
I am struggling with how to query a table with the current structure:
Field1 Field2 ...Field14 Jan Feb Mar Apr...
x y ...z 10 15 13 16...
etc,
It represents sales per month to customers per delivery adress,
product and so forth.The numbers under each month respresents the
sales for that month.
I need to be able to query so I can see all detalis (ie fileds 1-14)
per row per month, ie redistribute that original table so I can use
month as a field and still use all the original fields. My new table
needs to be something link
Month Field 1 Field2 ... Field14 New Field=Sales
Jan X Y .... Z 10
Feb X2 Y2 .....Z2 15
etc
For simplicity I have only illustrated one value per month but there
are sales per month as Reveniue, as kgs, as margin, etc
Any help to bring me in the right direction to query this would be
appreciated,
thanks
Lars
I am struggling with how to query a table with the current structure:
Field1 Field2 ...Field14 Jan Feb Mar Apr...
x y ...z 10 15 13 16...
etc,
It represents sales per month to customers per delivery adress,
product and so forth.The numbers under each month respresents the
sales for that month.
I need to be able to query so I can see all detalis (ie fileds 1-14)
per row per month, ie redistribute that original table so I can use
month as a field and still use all the original fields. My new table
needs to be something link
Month Field 1 Field2 ... Field14 New Field=Sales
Jan X Y .... Z 10
Feb X2 Y2 .....Z2 15
etc
For simplicity I have only illustrated one value per month but there
are sales per month as Reveniue, as kgs, as margin, etc
Any help to bring me in the right direction to query this would be
appreciated,
thanks
Lars