accessaspire219
Registered User.
- Local time
- Today, 08:02
- Joined
- Jan 16, 2009
- Messages
- 126
Hi Guys,
I have a cross tab query in which the column headings are months. As data gets added for the next month, a column will be added to the cross tab query for the additional month.
Now I have another query which is built off this cross tab query (basically a join between two cross tab queries)
Every time a column is added to the cross tab query for a new month, the column will not get added to the query that is built off the cross tab query since I manually selected the columns for this query.
I was wondering if anyone has a VBCode or some other way to automatically add the extra columns that come up in the cross tab query to the query built off the cross tab query.
Thanks.
I have a cross tab query in which the column headings are months. As data gets added for the next month, a column will be added to the cross tab query for the additional month.
Now I have another query which is built off this cross tab query (basically a join between two cross tab queries)
Every time a column is added to the cross tab query for a new month, the column will not get added to the query that is built off the cross tab query since I manually selected the columns for this query.
I was wondering if anyone has a VBCode or some other way to automatically add the extra columns that come up in the cross tab query to the query built off the cross tab query.
Thanks.