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
