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!

Register Log in
  • Congratulations derfloh 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: sql14
  • Order by date
  1. sql14

    Sub query - calculating totals, sub-totals by group

    Finally, sucess. Thanks to thread http://www.tek-tips.com/viewthread.cfm?qid=60632, located under the ANSI_SQL forum. I was able to figure this out with one query. The only issue I found, is that when the query is saved in access, the access software seems to put brackets [] around the...
  2. sql14

    Sub query - calculating totals, sub-totals by group

    I was hoping to try and accomplish the totals for the ship via within the same query, but it seems its not possible. I will try your solution though, thanks.
  3. sql14

    Sub query - calculating totals, sub-totals by group

    I am having problems with the following sub query calculation. What I would like to achieve is grand totals for all records, sub-totals by employee, then subtotals by shipping method. I can get the first two to work as expected, but the last subtotal by shipping method (TOT_FREIGHT) is not...

Part and Inventory Search

Back
Top