var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can a column be added to a query by not using Select All
I was wondering if someone knows of any way in which to do the following:
I have an Excel file which has already been pivoted and has months as the column headings and then counts in the rows underneath
I import the File into Ms Access.
1. The spreadsheet is updated with a new month each month, so I use Select all in my query in order to capture additional fields
2.By using Select all in my query, I am unable to do any sums on my query
3.My question is: Is there any way I can get the extra month which comes from my spreadsheet to automatically show in my query?
4.I know that a Select All and then a make table query will not work, as next month I will still have to add the extra month
Any ideas? I am open to VBA suggestions