Hello,
I am building an access report that is displaying a a query grouped by a category called "Section". This part is working fine, and the averages are appropriately summarized in the section footer. If I place "Section" as a field in the section header, I see the appropriate numerical value.
The problem is I would like to display a certain wording depending on the section. (i.e. =iif(Section = 1, "Section 1 wording".....)
Any kind of test I make with [Section] gives me back an error. Even just testing [Section] = 1 produces an error when running the report. I even tried VarType(Section) to be sure, and it gave me back 11 which appearently is an error code. I tried doing this in different sections of the report to see if there was a difference with no luck.
Any thoughts?
I'm realizing it would probably be easier to just build another table for these wordings and query them, but Im curious now as to why I am running into this issue. Let me know if more information will help.
Thanks!