ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> Financial Statements
http://www.istechforum.com/YaBB.pl?num=1212601839

Message started by Kelloggs on 06/04/08 at 10:50:39

Title: Financial Statements
Post by Kelloggs on 06/04/08 at 10:50:39

To get the Incone Statement - Current Year, I use the folling query:

INCOME STATEMENT - Current
-----------------------------------------------------------------------

SELECT
CInt(Trim([BKGL_ACCT])) AS ACCN,
Trim([BKGL_TYPE]) AS ACCT,
Trim([BKGL_ACCTD]) AS ACCD,
Trim([BKGL_GLDPT]) AS DPT,
CCur([BKGL_CURRENT_2]) AS CYAUG,
CCur([BKGL_CURRENT_3]) AS CYSEP,
CCur([BKGL_CURRENT_4]) AS CYOCT,
CCur([BKGL_CURRENT_5]) AS CYNOV,
CCur([BKGL_CURRENT_6]) AS CYDEC,
CCur([BKGL_CURRENT_7]) AS CYJAN,
CCur([BKGL_CURRENT_8]) AS CYFEB,
CCur([BKGL_CURRENT_9]) AS CYMAR,
CCur([BKGL_CURRENT_10]) AS CYAPR,
CCur([BKGL_CURRENT_11]) AS CYMAY,
CCur([BKGL_CURRENT_12]) AS CYJUN,
CCur([BKGL_CURRENT_13]) AS CYJUL
FROM BKGLCOA
WHERE (((CInt(Trim([BKGL_ACCT])))>3999));

What about the Balance Sheet (Our Fiscal Year start on August)??

Thnks

Kelloggs