Access Expression

[Dee2976]

I am having a hard time coming up with an expression that will allow me to count the amount of yes items in a column. I am using =count([columnneeded]) this expression of course tells me how many are in the column need. I would like for it to tell me how many yes items are in this column.

Any suggestions would be appreciated.

 

[PHV]

If columnneeded is a Boolean (True/False or Yes/no) field:
=-Sum([columnneeded])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Dee2976]

PHV when I tried your suggestion I receive an error saying that there is a data type mismatch in criteria expression. In the report section I programed this column to be a yes/no expression. I know there is a way to count the yes/no items separately. I just have to keep trying. Thanks if you have any other suggestions please Keep Them Coming.