Discussion Locked

LACKS OF CROSSTAB -MS ACCESS 97 !!!

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by catphish

I'm not sure I'm clear on what you're asking, but you might try this: Instead of creating the cross-tab directly from the form, create a regular select query using the form's date range. Then use the new query as the basis for your cross-tab. If this isn't what you're looking for, email me with a copy of the .mdb and I'll take a look. Catphish@pacbell.net

This discussion is closed to new replies.