I tried and I really thought that was going to work but it didn't. Is this set up right? It still says my total = NULL. I'll give you my full queries to see if anything else if affecting that, but it shouldnt.
SELECT
(-- Florida CC Payments --)
Select SUM (ISNULL(Amount, 0)) as "Total Commodity Paid for Florida"
From Contracts.dbo.Paymenthistory
INNER JOIN Contracts.DBO.Serviceaddr
ON Contracts.dbo.Paymenthistory.ServiceAddrID = Contracts.dbo.Serviceaddr.ServiceaddrKey
where Contracts.dbo.Paymenthistory.Billdesc like '%Credit Card%'
and Contracts.dbo.Paymenthistory.Receivedate >= '6/30/2012 00:00:00'
and Contracts.dbo.Paymenthistory.Receivedate <= '6/30/2012 23:59:59'
and Contracts.dbo.Paymenthistory.amount !< '0'
and Contracts.dbo.Paymenthistory.BillDesc not like '%Reapplied%')
+
(-- Georgia CC Payments --)
Select SUM (ISNULL(Amount,0)) as "Total Commodity Paid for Georgia"
From Phase1.dbo.Paymenthistory
INNER JOIN Phase1.DBO.Serviceaddr
ON Phase1.dbo.Paymenthistory.ServiceAddrID = Phase1.dbo.Serviceaddr.ServiceaddrKey
where Phase1.dbo.Paymenthistory.Billdesc like '%Credit Card%'
and Phase1.dbo.Paymenthistory.Receivedate >= '6/30/2012 00:00:00'
and Phase1.dbo.Paymenthistory.Receivedate <= '6/30/2012 23:59:59'
and Phase1.dbo.Paymenthistory.amount !< '0'
and Phase1.dbo.Paymenthistory.BillDesc not like '%Reapplied%')
+
(-- NorthEast CC Payments --)
Select SUM (ISNULL(Amount,0)) as "Total Commodity Paid for NorthEast"
From NY.dbo.Paymenthistory
INNER JOIN NY.DBO.Serviceaddr
ON NY.dbo.Paymenthistory.ServiceAddrID = NY.dbo.Serviceaddr.ServiceaddrKey
where NY.dbo.Paymenthistory.Billdesc like '%Credit Card%'
and NY.dbo.Paymenthistory.Receivedate >= '6/30/2012 00:00:00'
and NY.dbo.Paymenthistory.Receivedate <= '6/30/2012 23:59:59'
and NY.dbo.Paymenthistory.amount !< '0'
and NY.dbo.Paymenthistory.BillDesc not like '%Reapplied%'
and state != 'TX')
+
(-- Georgia Deposit Payments --)
Select SUM (ISNULL(Amount,0)) AS "Total Deposit Payments for Georgia"
From Phase1.dbo.AccountDepositActivity
JOIN Phase1.DBO.Serviceaddr
ON Phase1.dbo.AccountDepositActivity.ServiceAddrID = Phase1.dbo.Serviceaddr.ServiceaddrKey
where DepositType = '2'
And Phase1.dbo.AccountDepositActivity.PostDate >= '6/30/2012 00:00:00'
And Phase1.dbo.AccountDepositActivity.PostDate <= '6/30/2012 23:59:59'
And Phase1.dbo.AccountDepositActivity.UI = 'Adept - CS:creditcard')
As "Total Money From CC Payments For the Day"