Financial Statements

[Guest]

Has any one succesfully used the report function in access to produce a set
of Financial Statements - I already have a query that has hass the fields -
but I am having problems in formatting the reprt to show the feild in the
correct place and allow me to show sub totals.

Thanks
Danny

 

[Guest]

You will need to assign each account to a group or define a range of accounts
in a group, then you can subtotal on Income, COGS, Expenses, etc. You will
need to further define a grouping or calculated fields in your query in order
to get the Gross Profit. In your query you can do something like
IIF([AcctGroup]="Revenue",[Amount],0)
do the same for the COGS lines and then you can subtotal just those two in
the report for your Gross Profit.

Hope this helps.