Crosstable

[#1]

Good Morning,

if i type this command the script give me an error.

crosstable

(mese, qta, 4)

LOAD

CodiceProdotto,

Anno

,

TipoFornitore

,

Fornitore

,

QtaGennaio

as 1,

QtaFebbraio

as 2,

QtaMarzo

as 3,

QtaAprile

as 4,

QtaMaggio

as 5,

QtaGiugno

as 6,

QtaLuglio

as 7,

QtaAgosto

as 8,

QtaSettembre

as 9,

QtaOttobre

as 10,

QtaNovembre

as 11,

QtaDicembre

as 12

FROM xxxxxxx.mdb

but if i type this command

CONNECT

TO xxx.mdb

ALIAS

QtaGennaio AS 1;

ALIAS

QtaFebbraio AS 2;

ALIAS

QtaMarzo AS 3;

ALIAS

QtaAprile AS 4;

ALIAS

QtaMaggio AS 5;

ALIAS

QtaGiugno AS 6;

ALIAS

QtaLuglio AS 7;

ALIAS

QtaAgosto AS 8;

ALIAS

QtaSettembre AS 9;

ALIAS

QtaOttobre AS 10;

ALIAS

QtaNovembre AS 11;

ALIAS

QtaDicembre AS 12;

crosstable

(mese, qta, 4)

SELECT

*

FROM xxx.mdb

it work well.

But i need to use the first script because in the crosstable operation i have to select only some filed.

[#2]

Hi Margio,

It would be much easier for us to help if you will attach an example of the QV application.

Kind regards,

JTPro

[#3]

What is the error that you get?