• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

Grouping Ms Access

Grouping Ms Access

Hi
Sorry to bother you again, I’m again stuck on the final grouping on my balance sheet, what I want is as follow:

•      Fixed Assets +Current assets = Total assets (65000 + 105443) = 170443
•      Liabilities + capital + Profit & loss = Total Liabilities and capital ( 30434+65000+75009) = 170443
Kindly see my attached balance sheet for reference.

Regards

Chris
0
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Asked:
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
  • 3
  • 2
1 Solution
 
Ryan ChongCommented:
attached??
0
 
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAuthor Commented:
Okay find attached file for your reference
rptBalanceSheet.pdf
0
 
Ryan ChongCommented:
what you attached is the output.
we need the source file for debugging.
0
 
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAuthor Commented:
Sorry I'm not at home now to upload the report itself but here is the sketch below:

(1) Each section of the balance sheet is group by code balance type code, for example:
 -  200 =  Fixed asset ( That is the reason why you are seeing the fixed asset separate as per attached balance sheet)
 -  201 =  Current asset ( This grouped together with all those accounts assigned with this code)
 -  202 =  Current liabilities ( All accounts assigned with this code are grouped here)
 -  203 =  Capital  ( All capital related accounts are grouped here)

All what I'm asking whether it is possible to insert a control within the details to sum up ( Fixed Assets + Current Asset) and ( Current liabilities + capital)

I do not want to use sub reports
0
 
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAuthor Commented:
Sorry I cannot do what you want for security reasons , the matter is closed, however thank you for your assistance.

Regards

Chris
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now