I was hoping to not start a new thread, but i've not found anything searching here or google.
I have a sub-form (sourced from a query) that has two fields; Name (source: ItemName) and AuthYear (source: Year). In the footer of the sub-form I have a field that is supposed to count the number of rows that show the current year.
I tried Count([Year]=Year(Now())) only to learn that Access's count function doesn't work that way. I looked at DCount and used the name of the sub-form for the domain, but that didn't work. I looked for a CountIf equivalent but can't find one.
I thought I had tried all types of expressions in the Count(expr), including IIF. Somehow I missed (or messed up) something (more likely the latter). Your answer works exactly as required.