format microsoft query data
 

I returned several columns of data from a sql server db to an excel
worksheet. When I selected a column & tried to sum it, it whacked out all
the data. I don't know what it did, but it certainly wasn't a sum. How do
you work with external data once it has been returned?

format microsoft query data
 

What type of data were you trying to sum, and what does "whacked out" mean,
exactly?

Tim

"Johnslg" wrote in message
...
I returned several columns of data from a sql server db to an excel
worksheet. When I selected a column & tried to sum it, it whacked out all
the data. I don't know what it did, but it certainly wasn't a sum. How
do
you work with external data once it has been returned?

format microsoft query data
 

Number fields. 329 rows were returned. I just sumed the last two from one
column for an example.

Before sum:
300
300

After sum (the last value being the sum):
-200
-250
-300

If I cut the block of fields and paste them elsewhere in the workbook, I can
work with them. I tried breaknig the link back to SQL Server but that didn't
help. I suspect there is some sort of calculation going on somewhere, but I
just need to treat these fields as general.


"Tim Williams" wrote:

What type of data were you trying to sum, and what does "whacked out" mean,
exactly?

Tim

"Johnslg" wrote in message
...
I returned several columns of data from a sql server db to an excel
worksheet. When I selected a column & tried to sum it, it whacked out all
the data. I don't know what it did, but it certainly wasn't a sum. How
do
you work with external data once it has been returned?