Report Data Field Issue

[SilverSN95]

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!

[RuralGuy]

Using reserved words such as Section can have interesting effects.

[SilverSN95]

Thanks rural that turned out to be the issue, I really should have known to check that.
Even though I wasted a decent amount of time trying to figure this out its good to know its not an issue with my table/query!

[RuralGuy]

Excellent! Glad we could help.