View Single Post
  #1   Report Post  
Gary
 
Posts: n/a
Default Excel Query Via Sybase

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.