Here's my current SQL Query: SELECT SumOfPaymentOwed = CASE WHEN ISNULL(Sum(Amounts.PaymentOwed),0) = 0 THEN 0 ELSE CONVERT(DECIMAL(10,2),Sum(Amounts.PaymentOwed)) END FROM Amounts WHERE PaidDate is Null AND ClientID = '" & strClientID & "'"
This works fine. However, I'd like for it to show something like: Amounts Paid Since [PaidDate]. I'd like to find the first paid date (ex: 4/05/2005) in the database and display the results like: Totals Paid: $200 since 4/05/2005. Could someone please help me with this?
Topic Options
Post Options
Thanks(0)
