Hi
in Sybase create a query/view which just returns your desired value and
use this view as source for MS Query
--
Regards
Frank Kabel
Frankfurt, Germany
"Gary" schrieb im Newsbeitrag
...
Thank you in advance for reading the question.
I am using Excel and am trying query data from a Sybase server using
ODBC.
I underlying data in months and profit figures by product. The
spreadsheet
has column A (month) and column B (profits). I am essentially trying
to sum
up total profits in each month.
eg. Jan +800k
I tried using Microsoft Query, but am not sure how to have it only
return
the single total figure rather than a full blown query outoutput.
Any suggestions are appreciated.
|