| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL Query and Summary
Hi All,
Is it possible to make a summary at the same time of an SQL query? For eg. if I have various branches Detailed data in a Table, can I have a Query to get only the Total for each column for each Branch? I can be more specific incase this is possible TIA Soniya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SQL Query and Summary
Hi Soniya
Its done in SQL Like this: SELECT PRODUCT, REGION, SUM(AMOUNT) FROM SALES GROUP BY PRODUCT, REGION ORDER BY REGION HTH. Best wishes Harald "Soniya" skrev i melding ... Hi All, Is it possible to make a summary at the same time of an SQL query? For eg. if I have various branches Detailed data in a Table, can I have a Query to get only the Total for each column for each Branch? I can be more specific incase this is possible TIA Soniya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
