You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser.
Hi Please assist I have a field that stores Answer Yes and No as text as the field gets updated via other sources. I want to count the Yes answers.
(1 Viewer)
Hi Robert
You posted to Sample databases which is a moderated area and not used for asking questions. I moved it to forms.
Its unclear from your post whether Answers is a text field or a Yes/No field.
If its text then you need to put quotes around Yes in your expression.
If its Yes/No, suggest you replace Yes with True in the expression and don't use quotes.
Hi Robert
You posted to Sample databases which is a moderated area and not used for asking questions. I moved it to forms.
Its unclear from your post whether Answers is a text field or a Yes/No field.
If its text then you need to put quotes around Yes in your expression.
If its Yes/No, suggest you replace Yes with True in the expression and don't use quotes.