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
|