Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-15-2005, 01:44 PM   #1
chard2
Registered User
 
Join Date: Apr 2005
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
chard2 is on a distinguished road
multi calcs for report: best to use query or in code of report?

I have a checktracking database in which I need to have it generate a MIS/Inventory report. A screen print of the report is attached of how I want it to look like. There are numerous fields on the report that are going to require calculations from my table, ie: received numbers, completed, ending numbers, and aging, MTD/YTD as well. (your normal MIS/Inventory report I guess).

Question: What will be the easiest way to create this, do all of my calculations via a query, and then link the query to my report? (won't this make the query slow since I will have over 10,000 records in my one main table?)

OR

Do I do all of my calculation via code in the module of the report I am creating?

Any suggestions on how to create my MIS report in the most efficient manner would be greatly appreciated. By the way, does anyone know of, seen, or have a sample database that needs to create calculations like mine?

Thanks in advance for any help!
Attached Files
File Type: doc rptCheckMIS.doc (85.0 KB, 141 views)

chard2 is offline   Reply With Quote
Old 04-16-2005, 04:25 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,320
Thanks: 542
Thanked 941 Times in 892 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
First of all, I have no idea what MIS is an acronym for. Assuming that it is an acronym.

I have no idea of what type or form your calculations will take, however if you are concerned about whether to run them behind the report or from the query, then I would suggest that you develop your code in a module. You will then be able to call the functions you create in the module from the query or the report. So if at a future date you decide to change from one to the other it would simplify the process.
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 04-17-2005, 12:49 AM   #3
chard2
Registered User
 
Join Date: Apr 2005
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
chard2 is on a distinguished road
Multi calcs for report: best to use query or in code of reports?

Sorry for the confusion, that was my first post. Let me explain better my situation:

I have a database to track Checks received for borrowers with student loans:

table consisting of: received date
check type
status
check cut date
#customers per check
#loans

My report has to show many calculations, and I know how I want my report to look like. By the way, my table will have a large number of records, possibly up to 10,000+ records.

I need to know the most efficient/fastest way to populate my report with the calculations:

1) Do I calculate my items via a query
2) or in code of my report
3) or in a separate module, and in the code of my report call the calculations from the other module.
4) Since most of my calculations will be based on 3 or more columns from my table, is it best to use IF/Then statements in my calculations? (not really sure I know how to code for all the different calculations, guess I'll find out.)

I have attached an example of my table, and how my report is to look, along with the calculations needed. I've attached as an excel file that I zipped, I hope you can open it.

Thanks in advance for any help you see fit to provide.
Attached Files
File Type: zip Table_Report.zip (5.5 KB, 98 views)

chard2 is offline   Reply With Quote
Old 04-17-2005, 02:04 AM   #4
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,320
Thanks: 542
Thanked 941 Times in 892 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
I am still not sure about the purpose of your question.
it is difficult to offer any help at the moment because I get the impression you are not really sure of what you want yourself .

I would suggest that you attempt to develop your formulas, And if you become stuck, you can submit a question to this forum where I'm sure you will get some help.

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 08:55 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