Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: hugebreakthrough
- Order by date
-
How to slice data (groupped by row counts)
I have data like this: ID | Name | Points | 1 | Ronnie | 20 | 3 | Rene |22 | 6 | Tyrza |30 | 7 | Lynda |44 | 10| Edwin |10 | 11| Eddy | 77 | 12| Toni | 10 | How to query so I can have result like this (groupped by 2s): Ronnie, Rene | 42 Tyrza, Lynda | 74 Edwin, Eddy | 87 Toni | 10...- hugebreakthrough
- Thread
- Replies: 2
- Forum: MySQL
-
How to subtract sum() from 2 queries and return result in 1 row?
I need your help .... I have a table which name is tblQty with this fields: |Source|Target|Product|Quantity| I want to get the total stocks. Which currently I subtract the SUM result of quantity from target to source as STOCK IN with the SUM result of quantity from source to target as STOCK...- hugebreakthrough
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
