I have a table
personid classname Classtype enrollType ActiondateenrolledpersonIDclassnameClassTypeactiondateenrolltype1ABE1ABE4/3/2012en1cog1cognitive4/10/2012en1Microsoft1Microsoft4/10/2012en1mod1aMicrosoft4/10/2012en2ABE1ABE4/10/2012en2cult1cultural4/10/2012en2Microsoft1Microsoft4/3/2012en2mod2amod24/10/2012en3mod 1aMod14/3/2012en4ABE1ABE4/10/2012en4mod 2aMod24/10/2012en5cog1cognitive4/10/2012cm6cult1cultural4/10/2012ird7DV5dv4/10/2012en
I made a crosstab query and it shows how many are enrolled in the class but i need to know how many people are not enrolled in the class
enrolled_Crosstab2personIDTotal Of enrolltypeABE1cog1cult1DV5Microsoft1mod 1a1411
1
241
1
1
31
1421
51
1
61
1
71
1
Each column indicates whether a person has taken the class. For example ABE 1 has had three people take the class but the blanks mean 4 people have not taken the class. I need to know how many have not taken the class. How do I find the number of blanks for each column
personid classname Classtype enrollType ActiondateenrolledpersonIDclassnameClassTypeactiondateenrolltype1ABE1ABE4/3/2012en1cog1cognitive4/10/2012en1Microsoft1Microsoft4/10/2012en1mod1aMicrosoft4/10/2012en2ABE1ABE4/10/2012en2cult1cultural4/10/2012en2Microsoft1Microsoft4/3/2012en2mod2amod24/10/2012en3mod 1aMod14/3/2012en4ABE1ABE4/10/2012en4mod 2aMod24/10/2012en5cog1cognitive4/10/2012cm6cult1cultural4/10/2012ird7DV5dv4/10/2012en
I made a crosstab query and it shows how many are enrolled in the class but i need to know how many people are not enrolled in the class
enrolled_Crosstab2personIDTotal Of enrolltypeABE1cog1cult1DV5Microsoft1mod 1a1411
1
241
1
1
31
1421
51
1
61
1
71
1
Each column indicates whether a person has taken the class. For example ABE 1 has had three people take the class but the blanks mean 4 people have not taken the class. I need to know how many have not taken the class. How do I find the number of blanks for each column
Last edited:
