Forum Discussion
Newby trying to total all the Yes's
HI. I am not an Access user and know very little about it. I do use one Access 2007 database as one part of my job. I now need to create a report from it. I have figured out how to make the repor...
Thanks for your ideas, but when I type in either of those formulas I get an error- "Data type mismatch in criteria expression". I included a couple of screen shots showing what a portion of the report and the design screens look like. I tried putting your formula in the text box next to "total approved" where it currently says "unbound". Have I done something wrong?
it seems your Approval field is Short Text:
=Sum(([Approval] & "" = "Yes") * -1)
=Sum(([Approval] & "" = "Yes") * -1)