Not new to Access (definitely not an expert) but am new to posting in a forum, so please excuse any rookie mistakes. Need some help on using the Count feature on a report. If the response in a field is Yes and No, and I want to know the singular total of how many YES responses I have, in the control source of a text box I’m using =Count(IIf([fieldName]="Yes",0)) and I get my answer. The issue I have is on some reports, the field may have multiple responses (Yes, Sometimes, Seldom, Never). If I want the text box to give me total count of say YES and SOMETIMES combined, I’m not sure how to express that. I’ve tried different variations of the =Count attempting to join them to provide a cumulative, but the result is a 0 total. Any help would be appreciated.