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 |
All times are GMT +1. The time now is 07:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com