hi,
i have a crosstab query that generates up to 4 different columns depending on the query's result. the problem is, since these columns are not always there, i cant make a report with all four fields. cause then if one of them is not returned by the query, then i get a error message or the report is empty.
ok not very clear i guess...
ok for example :
i want to know wich class will each student attend.
Let say i have 4 different types of classes (class 1, 2, 3 and 4)
my query returns 10 of the students but all of them are attending the same first 2 classes. in this case my crosstab query will only generate columns for these two classes (i will have 2 columns instead of 4).
therefore, class 3 and 4 will not appear in the result. how can i make a report with that cross tab query and still display a space for each class.
(this is only an simplified example of my situation, my query would be more complicated to explain)
i have a crosstab query that generates up to 4 different columns depending on the query's result. the problem is, since these columns are not always there, i cant make a report with all four fields. cause then if one of them is not returned by the query, then i get a error message or the report is empty.
ok not very clear i guess...
ok for example :
i want to know wich class will each student attend.
Let say i have 4 different types of classes (class 1, 2, 3 and 4)
my query returns 10 of the students but all of them are attending the same first 2 classes. in this case my crosstab query will only generate columns for these two classes (i will have 2 columns instead of 4).
therefore, class 3 and 4 will not appear in the result. how can i make a report with that cross tab query and still display a space for each class.
(this is only an simplified example of my situation, my query would be more complicated to explain)
