LACKS OF CROSSTAB -MS ACCESS 97 !!!
DEAR LADIES AND GENTLEMEN ,
WHO CAN HELP ME WITH A SOLUTION ON ACCESS97 CROSSTAB ? SOS !
I HAVE A TABLE WHICH HAS THE STRUCTURE :
REC#1:FIELD1,FIELD2,...DATE-1,......FIELD10
REC#2:FIELD1,FIELD2,...DATE-2,......FIELD10
...........................................
REC#N:FIELD1,FIELD2,...DATE-31......FIELD10
DATE-1....DATE-31 ARE THE DAYS OF A MONTH.
FROM THIS TABLE I BUILD UP A QUERY INDICATING A PERIOD OF TIME FROM A FORM
USING THE CLAUSE "BETWEEN FORMS!NAMEF![TEXT1] AND FORMS!NAMEF![TEXT3]",WHERE
TEXT1 AND TEXT3 ARE CONTROLS ON THE FORM NAMEF . THE RESULT IS OK !!! ,OF COURSE .
IF I BUILD UP A CROSSTAB FROM THIS QUERY ,
THE CROSSTAB DOESN'T ACCEPT THE PERIOD OF
TIME INDICATED BY THE CLAUSE "BETWEEN....".
IF I PUT IN QUERY FIXED VALUES FOR THE FIELD
DATE-#, THE CROSSTAB WORKS VERY WELL !
DATE-1,DATE-2,...DATE-31 BECOME COLUMNS HEADING IN THE CROSSTAB .
I ALSO TRIED TO USE "PARAMETERS" FOR QUERY
INDICATING THE PERIOD OF TIME INSTEAD OF
CLAUSE "BETWEEN....."
THE SAME RESULT IN CROSSTAB !NOTHING !ERROR!
I THINK THAT IS A LACK OF THE CROSSTAB !
WHO KNOWS HOW TO SOLVE THIS PROBLEM USING
THE CLAUSE "BETWEEN ..." IN QUERY ,THUS THE
CROSSTAB BUILT ON THIS QUERY SHALL WORK ???
ANY SOLUTION IS WELCOME !
THANK YOU VERY MUCH IN ADVANCE !!!
PLEASE, HELP ME ...ASAP !
KIND REGARDS,
EMIL