accessaspire219
Registered User.
- Local time
- Today, 07:21
- Joined
- Jan 16, 2009
- Messages
- 126
Hi,
I have a query which contains monthly data. Every month a new column is added to the query. All the calculations are being done in the query and I am using the report just as a means to present the data. I will however need to have dynamic textboxes/labels on the report which will automatically show the additional data. I guess I will need to pre-add 12 textboxes and labels for each (potential) column and then have a code that will put the query results into the columns while hiding the unused columns on the report. Is there a way this can be done? I am not very good at VBA coding so any help in this regard will be appreciated.
Thanks.
I have a query which contains monthly data. Every month a new column is added to the query. All the calculations are being done in the query and I am using the report just as a means to present the data. I will however need to have dynamic textboxes/labels on the report which will automatically show the additional data. I guess I will need to pre-add 12 textboxes and labels for each (potential) column and then have a code that will put the query results into the columns while hiding the unused columns on the report. Is there a way this can be done? I am not very good at VBA coding so any help in this regard will be appreciated.
Thanks.
