dhookom,
i want the outpput to be displayed like
SumOfCashIn SumOfCashOut
$40,000.00
$15,443.02 $0.00
$10,215.62 $0.00
$3,661.78 $0.00
$8,290.00 $0.00
$9,814.51 $0.00
$6,779.00
$106,317.60 $0.00
$5,605.00 $0.00
$5,007.00 $0.00
$6,403.00 $0.00
$3,260.00 $0.00
$8,350.00 $0.00
$4,300.00 $0.00
$4,239.26 $0.00
$7,710.24 $0.00
$14,772.00 $0.00
$6,539.00 $0.00
however the query that i'm using seems not be pulling all the records accross.
here's the query i'm using
SELECT dbo_Transactions.BusinessDate, dbo_Transactions.CalendarDate, dbo_Accounts.AccountNumber, dbo_Accounts.Title1, db

rganizations.OrganizationName, db

rganizations.TypeOfBusiness, db

rganizations.EmployerID, Sum(dbo_Transactions.CashIn) AS SumOfCashIn, dbo_Transactions.CashOut As SumOfCashOut
FROM ((db

rganizations RIGHT JOIN db

rganizationLinks ON db

rganizations.OrganizationTag = db

rganizationLinks.OrganizationTag) RIGHT JOIN dbo_Accounts ON db

rganizationLinks.AccountTag = dbo_Accounts.AccountTag) INNER JOIN dbo_Transactions ON dbo_Accounts.AccountNumber = dbo_Transactions.AccountNumber1
GROUP BY dbo_Transactions.BusinessDate, dbo_Transactions.CalendarDate, dbo_Accounts.AccountNumber, dbo_Accounts.Title1, db

rganizations.OrganizationName, db

rganizations.TypeOfBusiness, db

rganizations.EmployerID, dbo_Transactions.CashOut
HAVING (((dbo_Transactions.BusinessDate)=#7/24/2006#) AND ((Sum(dbo_Transactions.CashIn))>=3000))
ORDER BY dbo_Accounts.AccountNumber;
UNION
SELECT dbo_Transactions.BusinessDate, dbo_Transactions.CalendarDate, dbo_Accounts.AccountNumber, dbo_Accounts.Title1, db

rganizations.OrganizationName, db

rganizations.TypeOfBusiness, db

rganizations.EmployerID, dbo_Transactions.CashIn, Sum(dbo_Transactions.CashOut) AS SumOfCashOut
FROM ((db

rganizations INNER JOIN db

rganizationLinks ON db

rganizations.OrganizationTag = db

rganizationLinks.OrganizationTag) LEFT JOIN dbo_Accounts ON db

rganizationLinks.AccountTag = dbo_Accounts.AccountTag) LEFT JOIN dbo_Transactions ON dbo_Accounts.AccountNumber = dbo_Transactions.AccountNumber1
GROUP BY dbo_Transactions.BusinessDate, dbo_Transactions.CalendarDate, dbo_Accounts.AccountNumber, dbo_Accounts.Title1, db

rganizations.OrganizationName, db

rganizations.TypeOfBusiness, db

rganizations.EmployerID, dbo_Transactions.CashIn
HAVING (((dbo_Transactions.BusinessDate)=#7/24/2006#) AND ((Sum(dbo_Transactions.CashOut))>=3000))
ORDER BY dbo_Accounts.AccountNumber;