I've got a table with the following columns ID, Subject , Q1, Q2, Q3, Q4
That's fine, so I'm building charts with the data from Q1, to Q4.
How can I automate next month, as I've done textbox expressions and charts for Q1 - 4, how can I automate the new columns Q5 with the expression and charts, charts and text boxes can be the same layout, I just need to populate an expression or table with the amount of Q I get each month, some can be 3 some can be 30 etc. And the questions will not be q1, q2, q3 etc, they will be random text.
Is this possible? crosstables and pivot tables perhaps?
I am not sure I understand your requirement might be this
'Q' & ceil(month(datefield)/3) + rowno() as quarter
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
