access SQL to pull all fields in a table and group them based on their ID

I have this table with these fields:

Employee ID
sum of expenses aug-12
sum of expenses sep-12
sum of expenses oct-12
.
..
...
Up until the last field that would always be named "total of sum expenses".


One employee ID could have multiple "sum of expenses aug-12", etc..

I would like to create a query that group all of the fields based on Employee ID and sum all of the "sum of expenses" fields..

The fields names could vary month to month, thus I want to create a SQL statement that pull all of the "sum of expenses" fields regardless of the names of the fields...

Thanks!

Is this table based on another table?

Your tables are not normalized.

Look at this white paper on design.

http://www.deeptraining.com/litwin/d...aseDesign.aspx