Results 1 to 40 of 43

Thread: [RESOLVED] More SQL Questions

Threaded View

  1. Nov 26th, 2007, 01:44 PM #1
    jhize
    jhize is offline

    Thread Starter
    Lively Member jhize's Avatar
    Join Date
    Dec 2006
    Posts
    87

    Resolved [RESOLVED] More SQL Questions

    In this thread (http://www.vbforums.com/showthread.p...hlight=sql+sum) the following code was posted:

    Code:
    "SELECT type, SUM(amount) AS totals FROM history GROUP BY date, type HAVING date = '" & Combo1.Text & "' ORDER BY date"
    My question is simply this:

    Where does the "..As totals" come from? I need to do something similiar but I'm not sure about this portion of the above code. I need something like this, I think:

    Code:
    "SELECT SUM(Payment) FROM Paydate WHERE CommonPropertyName ='" & Propertyname & "'"
    Last edited by jhize; Nov 27th, 2007 at 01:32 PM.
    The question is not, Can I?
    The question is, How Do I?

    SQL Syntax | More SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width