S
slapana
I'm using MS Query/SQL to pull data from a database that holds accounting
information.
I have a column (fee) that represents a payment that was made, so,
obviously, the number is negative. In SQL, I can change the code to multiply
the column by -1 (-1*fee)to make the data positive and everything works fine.
However, when I refresh the data in my spreadsheet, it takes that field and
moves it to the last column. Do Pivot Tables in Excel expect the columns in
a certain order, or does it only look for a matching header, regardless of
location? If the former is the case, how to I get Excel to keep the columns
in the same order as the columns in my SQL query?
information.
I have a column (fee) that represents a payment that was made, so,
obviously, the number is negative. In SQL, I can change the code to multiply
the column by -1 (-1*fee)to make the data positive and everything works fine.
However, when I refresh the data in my spreadsheet, it takes that field and
moves it to the last column. Do Pivot Tables in Excel expect the columns in
a certain order, or does it only look for a matching header, regardless of
location? If the former is the case, how to I get Excel to keep the columns
in the same order as the columns in my SQL query?