Hi,
Could you help me out in this?
I'm doing calculations; for every month I create a column (1 to 12) and this column is being populated with numbers, customer by customer. This is being done for YearFirst and YearLast. Next, I calculate the difference for every month and so I end up with 12 columns, containing the difference in sales by month, named '01', '02', '03'. Or '1','2','3' if that is more convenient to the below question.
Now, to calculate the YTD (YearToDate) value, I only need a certain amount of columns: up to the (Month(Now)-1) column. If I can call this in a query, I would be ready. How to do this?
With kind regards,
Timo
Could you help me out in this?
I'm doing calculations; for every month I create a column (1 to 12) and this column is being populated with numbers, customer by customer. This is being done for YearFirst and YearLast. Next, I calculate the difference for every month and so I end up with 12 columns, containing the difference in sales by month, named '01', '02', '03'. Or '1','2','3' if that is more convenient to the below question.
Now, to calculate the YTD (YearToDate) value, I only need a certain amount of columns: up to the (Month(Now)-1) column. If I can call this in a query, I would be ready. How to do this?
With kind regards,
Timo
