Sergiy is correct about the poor design but :

SELECT 'Cash' AS PaymentType, SUM(Cash) AS [Total] FROM Ledger WHERE mydate BETWEEN...  

UNION ALL

SELECT 'Cheque', SUM(Cheque) FROM Ledger WHERE mydate...

Andy,

Ground to a halt? Perhaps the source could be published somewhere for comments... I'm sure it's not a major factor - but at least the one's which simply don't work...