View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Walter[_5_] Walter[_5_] is offline
external usenet poster
 
Posts: 5
Default query sql database

Hello everybody

I need to import in a Excel sheet data from a Microsoft sql database,
I need the filtered data from some fields from one table and from a
other table which needs to be linked with a field the calculated sum from
the many related records.

Table one Table two, item nr.
field to be linked with table one

filtered
item nr-------------------------------------item nr / quantity
quantity
quantity
quantity
---------------------
sum

sheet result

item nr sum (quantity)

I can do everything except get the single result from the summed quantity
field

Anybody a idea how to achieve this?

Thanks

Walter