Use Expression as Column Name

[padlocked17]

Use result of Expression to retrieve Value of a Field name(Generated by Expression)

All,

I've got an expression that identifies which column I want to reference in a query. I have field names called Jan_ACC, Feb_ACC, Mar_ACC, etc.

I then have an expression that determines which month it is and appends "_ACC" at the end. I was hoping to then use this expression in another expression and somehow include a "[" and "]" around it so that I could reference the column based on the name I generated. How would I go about this?

The expression to determine the name is

ThisMonth: MonthName(Month(Date()),True) & "_ACC"

How I'm trying to use it:

RemMonth:  IIf([Month_REQ]>0,IIf([ThisMonth]>0,"Done this Month","Not Done this Month"),"Not a monthly event")

 

[valverde311]

Did you ever figure out the solution? I am trying to do something quite similar.

 

[boblarson]

It would need to be done through VBA code and if there are columns like that then it is not properly normalized.