Perfect! Thanks!
On 6/4/07, Armaghan Saqib <[EMAIL PROTECTED]> wrote:
For a single account (31488) balance up to a particular 31-Dec-2006:
==
SELECT SUM(amount)
FROM acc_trans
WHERE transdate <= '31.12.2006'
AND chart_id IN (SELECT id FROM chart
For a single account (31488) balance up to a particular 31-Dec-2006:
==
SELECT SUM(amount)
FROM acc_trans
WHERE transdate <= '31.12.2006'
AND chart_id IN (SELECT id FROM chart WHERE accno='31488')
For a range of accounts:
==
SELECT
Hello!
I need to write a query that will give me the value of a balance sheet
account on a specific day. I know I could generate a balance sheet report,
but then I'd have to parse it to get what I need. There are several layers
that I'm going to wrap the query in; I just don't know how to do th
