Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-08-2019, 04:04 AM   #1
pmxpo
Newly Registered User
 
Join Date: Jul 2019
Location: Abuja, Nigeria
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
pmxpo is on a distinguished road
MS Access Monthly financial report

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.
Attached Files
File Type: xlsx Database_abc.xlsx (151.8 KB, 14 views)
File Type: xlsx FAAC Report.xlsx (278.6 KB, 11 views)

pmxpo is offline   Reply With Quote
Old 07-08-2019, 05:21 AM   #2
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,394
Thanks: 89
Thanked 1,650 Times in 1,532 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
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.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is online now   Reply With Quote
Old 07-08-2019, 06:32 AM   #3
pmxpo
Newly Registered User
 
Join Date: Jul 2019
Location: Abuja, Nigeria
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
pmxpo is on a distinguished road
Re: MS Access Monthly financial report

Quote:
Originally Posted by The_Doc_Man View Post
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

pmxpo is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need HELP.. New To Access how to condence a report and making it a monthly report F.E.A.R 2 Reports 3 12-02-2009 03:55 PM
How to Create Employee's Monthly Production Report in MS Access Version: 2007 pavinm Reports 3 05-05-2009 08:29 AM
Generating Monthly Report in MS ACCESS sahil Reports 8 01-16-2004 03:48 AM
[SOLVED] Generating a monthly report from a non access DB jtracy Reports 1 02-19-2002 10:51 AM




All times are GMT -8. The time now is 07:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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