column heading total in subquery 1

[Lazc]

hey guys, i have been asking a lot of questions lately but i really need to finish this app quick !!!

i have a crosstab query that has 4 column headings (fixed) when executing my query, i get a certain number of query that might or might not have values in some of the 4 columns.

what i want is to display the total of values in each colum (count).

is there a way to do that.

for example :

students class 1 class 2 class 3 class 4
David x x
Isabelle x x
Alex x x
Sharon x x

total 2 2 4 0

 

[Lazc]

hey great... i found the solution myself... i just need to make a new field in my report that makes a count of the fields i want to know. in the properties of this field, i only specify, in the running sum : "over group" and it calculates the total...

thanks to me !!!

 

[lespaul]

then have a star on me!



Leslie

 

[Lazc]

WOUHOU!!!!! thanks !