hi everyone
Ive got a self updating crosstab query, its essentially a monthly summary and every month a new column is added (one corresponding to the current month, ie next month the new column will be may, following that the new one will be june, etc)
ive designed a report to be based on this query and i tested it out by manually adding data for next month into a table, the query auto updated however the report remained the same (ended in april instead of adding a new column for may)
Just curious if there is a way to automatically add these new columns to the report every month or will i have to do so manually?
Ive got a self updating crosstab query, its essentially a monthly summary and every month a new column is added (one corresponding to the current month, ie next month the new column will be may, following that the new one will be june, etc)
ive designed a report to be based on this query and i tested it out by manually adding data for next month into a table, the query auto updated however the report remained the same (ended in april instead of adding a new column for may)
Just curious if there is a way to automatically add these new columns to the report every month or will i have to do so manually?
updating report based on crosstab query
