Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Lost in Microsoft Query | Excel Worksheet Functions | |||
import data with microsoft query | Excel Programming | |||
Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
Microsoft Query: retrieve data by dates | Excel Programming | |||
Using Microsoft Query to Extract Data | Excel Programming |