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"