Hi all i have created the following query
SELECT SUM(OutstandingValue) AS Sum_OutstandingValue
WHERE (it_due <= '06-30-2012')
SELECT SUM(sa_trvalue) AS Sum_invoiceValue
WHERE (sa_trdate >= '07-01-2011') AND (sa_trdate <= '06-30-2012')
i think i have used the wrong function basically what i want to do is to add the sum from the first query to the sum of the the secound query to give me a total figure.
i have used the union all which places both values on seperate rows i just want the one value of both added together.