Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Reports (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=10)
-   -   MS Access Monthly financial report (https://www.access-programmers.co.uk/forums/showthread.php?t=305780)

pmxpo 07-08-2019 04:04 AM

MS Access Monthly financial report
 
2 Attachment(s)
Dear All,

I would need some assistance in producing a monthly report from a database.

Please find attached both files (Database and the proposed report).

Thanks in anticipation for your help.

The_Doc_Man 07-08-2019 05:21 AM

Re: MS Access Monthly financial report
 
First (to get it out of the way), we have several headers in the forum. You probably should have posted this under GENERAL or REPORTS. But don't take that as a "knock" on you, because we see this all the time. A moderator will probably move this at some point. We know it happens and it isn't a really big thing - but it CAN affect how quickly you get a more directed response, so it is to your advantage to make new questions under their proper headings.

Second, looking at the "database" spreadsheet, you have some normalization to do. I respectfully suggest you need to do some reading so that you understand the concept of database normalization. I put that phrase in bold because that is the topic you would use on a general web search. If you used this forum's SEARCH feature, you could leave off "database" because this is a database forum. On a general search, though, you need to qualify it because other disciplines use the term "normalization" in other ways.

Other reading that would be useful for you if you aren't familiar with them would include use of the SQL keyword phrases "GROUP BY" and the functions SUM and COUNT.

pmxpo 07-08-2019 06:32 AM

Re: MS Access Monthly financial report
 
Quote:

Originally Posted by The_Doc_Man (Post 1629889)
First (to get it out of the way), we have several headers in the forum. You probably should have posted this under GENERAL or REPORTS. But don't take that as a "knock" on you, because we see this all the time. A moderator will probably move this at some point. We know it happens and it isn't a really big thing - but it CAN affect how quickly you get a more directed response, so it is to your advantage to make new questions under their proper headings.

Second, looking at the "database" spreadsheet, you have some normalization to do. I respectfully suggest you need to do some reading so that you understand the concept of database normalization. I put that phrase in bold because that is the topic you would use on a general web search. If you used this forum's SEARCH feature, you could leave off "database" because this is a database forum. On a general search, though, you need to qualify it because other disciplines use the term "normalization" in other ways.

Other reading that would be useful for you if you aren't familiar with them would include use of the SQL keyword phrases "GROUP BY" and the functions SUM and COUNT.

Thanks for your simplified and vivid response. I am actually new on the platform and I see there is a lot to learn.

Please forgive my curiosity in getting this particular report sorted. I will appreciate some assistance in fixing this report soon.

Regards


All times are GMT -8. The time now is 01:35 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World