count problem
I have a processedActivation table with text field that has a letter of the alphabet in it. I’d like to create 2 fields in my query, one that will tell me how many records contain “A” and another field that will tell me how many fields don’t contain “A”. What functions ought I be looking at since all my tests using a combination of COUNT( ), SUM ( ) and IIF ( ) in the criteria have been all for naught.
I have a processedActivation table with text field that has a letter of the alphabet in it. I’d like to create 2 fields in my query, one that will tell me how many records contain “A” and another field that will tell me how many fields don’t contain “A”. What functions ought I be looking at since all my tests using a combination of COUNT( ), SUM ( ) and IIF ( ) in the criteria have been all for naught.
