Dear 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

Many Thanks
Helen