Make column name flexible

[dani9]

HI,

does anyone know how to make the column name flexible. like for example I would need the name for July be changed each month. This is my query, or at least a part of it:

IIf([Start Date]<"2011-08" And [Close Date]>"2011-06",1,0) AS [2011-07],

so i would need the last part AS [2011-07] like [Format(DateAdd("m",-2,Date()),"mmm")] but this doesn't work (it comes the same in the report).. is there another solution, I could make column name variable???

[June7]

If you feel need to do this, sounds like database is not properly structured.

[dani9]

If you feel need to do this, sounds like database is not properly structured.

I have Start date column, and End date column, and I need to make columns for 12 months or more, showing if the application has been active for each month - 1 if active and 0 if not.

If i had one column with data, i could make a pivot table, but this way with two columns is complicated for me, I don't even know if it is possible.

Any ideas?

[June7]

Your requirement is similar to this http://forums.aspfree.com/microsoft-...st-469513.html

[dani9]

I already had this query, but doesn't fit my needs, as I said I need the column name to be flexible. In this case the columns are fixed.

[June7]

Far as I know, flexible column name is not possible. If you want report to automatically recognize the changed field names and 'adjust', as in change the ControlSource property of textboxes, this will require elaborate VBA coding.

[dani9]

ok, thank you anyway, I found another way around to solve my problem.

Thanks again for trying