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