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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by samcham

  1. samcham

    Need help with query errors

    George: Yes, I think it does. I'm heading out for the weekend, but will start working with this on Monday. Thanks again for all your help! ----------------------------- Using microsoft SQL Server 2005 (I'm a beginner at this, so please forgive the "noob" questions...)
  2. samcham

    Need help with query errors

    George: I did forget to mention that I'm using SQL Server Reporting Services (2005). I took a 3-day class in SSRS, and can use the program. But it's useless without the basic T-SQL query, and that's where I'm struggling. I haven't found anything in my SSRS materials that sheds any light on...
  3. samcham

    Need help with query errors

    George: Thanks very much for the quick reply. The query did indeed work. I didn't realize that I needed to include other fields in the GROUP BY statement. (This is all part of my learning curve.) Now, I have another question. This is a report that I need to run every day, and it needs to...
  4. samcham

    Need help with query errors

    My table (GlAccountAmounts) has the following columns: SourceID DateTime AccountID AccountClass AccountClassType AccountControlAccount AccountCorporation AccountCorporationName AccountDescription Balance Credit Debit RowUpdateDateTime I want to show totals for the Debit and Credit columns, by...
See more

Part and Inventory Search

Back
Top