Crosstab query doesn't bring all fields

[oyam]

Hi,

I have a crosstab query that runs well in Access, brings some of data when run in ASP, but not all the data.
The query:

SELECT TBLE, ADJ_CODE,
SUM(DECODE(DAY, '01-MAY-01', ext_val)) "01-MAY-01",
SUM(DECODE(DAY, '02-MAY-01', ext_val)) "02-MAY-01",
SUM(DECODE(DAY, '03-MAY-01', ext_val)) "03-MAY-01",
.
.
SUM(EXT_VAL) "TOTAL"

from....

In Access, I get numbers for every column, but in ASP I get only the TOTAL numbers. Any ideas?

Thanks,

Osher