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!
Bookmarks